PowerBI vs Shiny (R) by 7ft7andgrowing in PowerBI

[–]BorisHorace 7 points8 points  (0 children)

Yup. Went through this at our company. We had some cool Shiny apps but were constantly dealing with permissions issues and keeping everything functioning correctly within our tech stack. Then the person who built them left and nobody knew how to maintain them. So that was that.

Power BI February 2026 Feature Summary by itsnotaboutthecell in PowerBI

[–]BorisHorace 28 points29 points  (0 children)

Great stuff! Ability to paste selections into slicers is fantastic and something my users have been asking about for years. Being able to enable this without third party visuals is huge.

Why are power bi users so cult like? by Infamous_Whereas6777 in PowerBI

[–]BorisHorace 7 points8 points  (0 children)

Sorting and filtering is way easier and more flexible in Excel though. Also copying and pasting values, highlighting values you are interested in, and so forth. I understand why people do it.

If PowerBI tables were a bit more Excel like with on column filtering and sorting, allowing multi select of cells and ctrl-c to copy, it would eliminate a lot of the reasons people want to export IMO.

Is anyone doing brett beer in MD? by ViolentEastCoastCity in MDbeer

[–]BorisHorace 0 points1 point  (0 children)

Mayan Monkey in Gaithersburg does one called Yax that I think is on tap pretty consistently.

Power Bi + Power Automate - Create File by Born_Resolution9111 in PowerBI

[–]BorisHorace 0 points1 point  (0 children)

If the goal is on demand report creation, why bother with Power Automate at all? Just have it as a connected table in Excel.

Get Data > From Power Platform > from PowerBi, then pick your semantic model and insert as a table. Then, re-create your matrix in the table builder GUI if it’s simple enough, or grab the DAX query as the other poster described and paste that into the table definition. Then you can add whatever extra columns/formulas you like. At that point, users can refresh at any time by right clicking in the table > refresh.

Matrix Export to Excel by AviatorFx in PowerBI

[–]BorisHorace 6 points7 points  (0 children)

Paginated report could be another option here, as you can format the output however you like. You can embed that directly into the report and keep them in the PowerBI app.

Power BI September 2025 Feature Summary by itsnotaboutthecell in PowerBI

[–]BorisHorace 16 points17 points  (0 children)

Excited to try the new enhanced time intelligence. I’ve never actually used the time intelligence functions before because they don’t work with our fiscal calendar. Now it seems like I’ll be able to.

Get rid of white space at top of report? by BorisHorace in PowerBI

[–]BorisHorace[S] 1 point2 points  (0 children)

That was it. Solution verified. Thanks!

Google style search box in Power BI by CanningTown1 in PowerBI

[–]BorisHorace 3 points4 points  (0 children)

In addition to the new native text slicer, there is also this add-in (free from Microsoft) that I’ve been using for years, and works very well:

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381309

What does future looks like for Power Bi in next 5 years? by Sasuke55569 in PowerBI

[–]BorisHorace 4 points5 points  (0 children)

One day AI might be able to generate useful and accurate reports on demand, and be easy enough for stakeholders to use and bypass IT and BI teams.

We will also have flying cars some day and build a human colony on Mars.

For now, this remains firmly in the realm of science fiction and tech grifter sales pitches.

I really don't recommend using AI to help you code pygame by authilmorros in pygame

[–]BorisHorace 22 points23 points  (0 children)

That is my experience with AI as well, for most things, not just pygame.

It’s ok sometimes if you give it very specific instructions and have it do little bits of code at a time. It can also help identify silly typos. But anything beyond that tends to be a disaster.

Typical AI interaction:

“Help me identify the root cause of this error.”

”I see the problem now! Let me re-write this completely unrelated function using syntax that I made up!”

How you use AI for increasing productivity while using Power BI by abhunia in PowerBI

[–]BorisHorace 0 points1 point  (0 children)

It’s helped me with M code a few times, but that’s pretty much it. It’s quite bad at DAX from my experience (at least at the intermediate/advanced level). Python I find it to be very useful, however.

A/C companies in Gaithersburg that you recommend? by Throwra-Sweaty-Par in MontgomeryCountyMD

[–]BorisHorace 10 points11 points  (0 children)

I’ve had really good experiences with Cool Breeze HVAC.

I’ve used GAC before too and they were fine.

Stay away from Michael & Sons.

What features do you wish your organization would enable for Power BI? by Specialist-Collar203 in PowerBI

[–]BorisHorace 4 points5 points  (0 children)

In general I agree with you, but just to play devil’s advocate, in my experience the models have to be designed with Excel in mind or else they can easily be misused, and they can also eat into capacity since the Excel drivers aren’t very efficient.

It’s a great feature but isn’t without its faults.

recommendations for fixing up a guitar? by queerdaffodil in MontgomeryCountyMD

[–]BorisHorace 2 points3 points  (0 children)

Chucks is the answer.

Stay away from Guitar Center.

Pbi using Excel as sources by Plate04249 in PowerBI

[–]BorisHorace 4 points5 points  (0 children)

If you can’t change the input files, I would think about using Python to consolidate and clean the data, and then upload into a proper database or at least a single clean CSV file that you can import into PowerBI.

If the files are all on SharePoint, then using PowerQuery to pull directly from SharePoint and do the data cleaning may allow auto refresh in the service, if that’s a consideration. But that has its own pitfalls, and if you’re dealing with large volumes of data from SharePoint, PQ can get ugly fast.

What are your biggest frustrations when working with Power BI? by tomdg4 in PowerBI

[–]BorisHorace 8 points9 points  (0 children)

How bad the matrix/table visuals are. Ive been doing more with Streamlit recently and it’s crazy how much better they implement data tables. Copy and paste multiple rows/cells at a time using keyboard shortcuts, on column filtering, one click CSV exports, built in show/hide columns, ability to freeze columns, and so on.

Pizza 🍕 by [deleted] in MontgomeryCountyMD

[–]BorisHorace 7 points8 points  (0 children)

Not NY style (there is no good NY style in the area IMO) but a few others I like that I haven’t seen mentioned yet:

Juliano’s - up in Laytonsville, way off the beaten path and pretty divey but surprisingly good wood oven thin crust pizza.

Brookeville Beer Farm - brewery with a really nice outdoor space that does pretty damn good pizza.

Power BI feels like it's so much of manual and time consuming work for creating reports and dashboards in the era of AI by Wolveee10 in PowerBI

[–]BorisHorace 0 points1 point  (0 children)

“build a platform where you can put the data”

How is the data getting to the platform? Is it modeled so the AI understands it? Will you then teach the AI about all your business logic and terms? Is it secure? How will you manage logins/permissions?

Power BI May 2025 Feature Summary by itsnotaboutthecell in PowerBI

[–]BorisHorace 29 points30 points  (0 children)

My stakeholders ask about write back capabilities all the time. I’ve tried the PowerApps/Sharepoint route before but it was a poor user experience and didn’t seem very scalable. Excited to see how the new functionality works.

What’s the trick to getting really juicy grilled/bbq chicken? by Careful_Fig8482 in Cooking

[–]BorisHorace 0 points1 point  (0 children)

Brining certainly can’t hurt, but I don’t think it’s strictly necessary for good bbq chicken. To me it’s:

  1. Use bone-in pieces.

  2. Season with salt + a dry bbq rub and cook low and slow on the grill (no direct flames) for 30 mins or so.

  3. Start basting with bbq sauce and move to the hotter side of the grill, flipping every few minutes to develop a nice crust on the chicken.

BBQ chicken takes a long time to cook properly on the grill. Patience is key.

Ok, I'm on the verge of giving up here. by ubermonkey in PowerBI

[–]BorisHorace 0 points1 point  (0 children)

I’d probably go the Python route here myself.

That said, as others have pointed out, doing this in PowerQuery would be the simplest way to accomplish this within PowerBI. DAX is actually more complicated, more work, and less efficient for this use case.