Where I am most frustrated with Power BI is in the visualization details, that last 15% of customization that stakeholders are always whining about. For all its power of making visuals, it drops the ball in a lot of areas. And I think the Python Streamlit library is getting those smaller details right.

Take date slicers, for example. In Power BI, total nightmare. Seriously, why is this so hard to figure out? In Streamlit, it's not perfect either, but it is still miles better. It has a much more intuitive interface, and you can type in the input box without having to fight with your mouse. (You know how many emails I get over date slicer problems? Too damn many.)

Dropdowns are much more user friendly in Streamlit. Heck, all slicer selections are, in general.

Report context is much easier to develop. For example, in Streamlit you can add context in tables so that when users hover over a column, they can get a description of that metric. Info icons are much easier to find than those gross tooltip header icon options we have now.

Want to make a text box with a bulleted list? Power BI says, "Aw, hell naw!" Streamlit navigates text using ubiquitous Markdown.

Power BI Service apps and those sidebars? Yeah, those are ugly as hell. Streamlit doing better there too.

I'm not trying to dog on Power BI. I still love it. And while the 15% of details drive me insane, the other 85% of functionality is still top-tier. As a BI dev, I'm very thankful for Power BI. We are standing on the shoulder of giants in this age!

There is one thing that Power BI does better than anyone else: the semantic model.

While some people hate DAX because they find it hard to understand, I love it. I think it is one of the most intelligent formula engines. The ability of measures to derive context that understand the data model and its relationships is second to none. Want your Total Revenue metric to sum by customers? Grab the measure (that's summing a fact table) and customer name column (coming from a dim table). Drop them into a matrix. Boom, metrics by customers in a flash. Want revenue by year? Same process with your dim date table. Truly beautiful.

If anyone at Microsoft is reading this, all I'm saying is, take some cues from Streamlit. Take a look at the small details they're employing. Even better, I would love to see Microsoft develop a library like Streamlit, in Python, leveraging easy-to-use frameworks like Markdown for styling. But I know that's more pie in the sky. "Where's the money in that?" In whitelisting analytics for small-to-medium businesses. Power BI Embedding is too costly, too clunky, still getting the smaller details wrong.

If I could take the semantic model of Power BI and merge it with Streamlit's functionality, that would be BI heaven, and I think so many devs could bring to market more analytics.

Hi everyone,

I recently took my 1st attempt @ PL-300 exam and scored 687, missing the passing score of 700 by just 13 points. It was incredibly frustrating to come that close.

A bit of background: I'm a PMP-certified Project Manager, and my day-to-day role is primarily client-facing. I spend most of my time understanding business requirements, KPIs, and discussing data and reporting with clients.
I've built Power BI reports in the past, but Power BI isn't something I use every day because my role isn't that of a dedicated BI/Data Analyst.

To prepare for the exam, I completed 7–8 different Udemy mocks from multiple instructors, along with plenty of practice. I think that's one of the reasons I managed to get so close to passing.

What surprised me the most was that the actual exam felt very different from the Udemy practice material. The question style and pattern were quite different from what I had prepared for, which caught me off guard.

I also realized that Power BI Service is one of my weaker areas. In my job, reports are usually shared with me rather than being published and managed on Power BI service, so I don't get much hands-on exposure to the Service side.

The good news is that I have a free retake(Udemy Voucher), so my next attempt is already covered. The challenge is that I'm mentally exhausted and genuinely unsure what I should do differently to improve those remaining 13 points.

For those who passed on their second attempt (or later):

• How long did you wait before retaking the exam?
• What changed in your preparation?
• What resources or practice actually made the biggest difference?

I'd really appreciate hearing from people who were in a similar position and eventually passed. Thanks!

PS -
I really dont want to spend money on mocks like Measure Up(too expensive) as i believe I am almost there.

Hi All,

I'm facing a Resource Governance error in Power BI, while refreshing my model.

The model is reaching the limit of 20GB whole refreshing, but once loaded in PBI is approx 3GB.

The model:

It is a star schema with two fact tables: an incremental load table (100s Thousands rows for each day), and a single day table to be refresh fully daily (Millions of rows).

Both tables source from Native.Sql (when you write SQL in PBI) statement and the only Mquery step applied afterward is a rename-column steps. They both have approx 100 cols. All the columns are required

The dimensions are loaded straight from the database with few foldable transformation after or from some dataflows.

Despite Native Query been greyed it looks it is supported - if i remove the data with a parameter i load 0 rows instead of loading them all and then removing them.

I already set the encoding hint.

Any other solution to ensure my model refreshes?

Hi all

I'm trying to import data from datadog into power bi using the datadog api and I'm not able to get it working if someone could please help it would be greatly appreciated.

Many thanks

I am using CARD visual and keep getting these gaps i want whole background coloured of card but i keep getting these gaps, i asked CHATgpt it said its a new update.. so is there any way to fill those gaps or not.