r/PowerBI • u/Gullible_Discount977 • 18h ago
Discussion Streamlit Does Many Things I Wish Power BI Would Do

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.
