Advanced Power BI Custom Visuals: Options & Tradeoffs
Power BI is strongest for its built-in Power Query ETL and powerful Vertipaq tabular engine, but it’s not renowned as the crispest visualization tool on the commercial BI scene (most… Read more »
Category: Power BI
I’m Officially An International Man of Mystery!
I recently had a blast talking with Rob Collie and Tom LaRock on their Raw Data podcast, covering some of my eclectic obsessions from international arbitrage and public deficits to… Read more »
How to Use LastPass with Power BI Desktop
Unlike Office desktop applications, Power BI Desktop doesn’t keep track of more than one account at a time, which is quite annoying for people like myself who work across several… Read more »
Row Level Security & Beyond in Business Intelligence Applications: A Practical Overview
The ability to filter data by user is critical whenever sensitive information is shared, whether internally to an organization or even more so externally. This is often known as “row… Read more »
How to Hijack Power BI Styles to Apply Your Own
In a previous entry we saw how to use Cascading Style Sheets with Power BI’s HTML Content visual do apply dynamic visual effects outside what’s commonly expected within the platform…. Read more »
How to Pimp Your Power BI Reports with Dynamic CSS in the HTML Content Custom Visual
Microsoft Power BI rose to its leading position in the BI market on the back of its top-shelf PowerQuery self-service ETL and VertiPaq in-memory engine as well as its familiarity… Read more »
Refreshing Power BI Datasets & Dataflows with APIs and Power Automate
When Microsoft introduced Power BI dataflows at the end of 2018 to separate no/low code cloud ETL from BI modeling and visualization, many people were initially confused about how refreshes… Read more »
Use the Schema Tools in Microsoft Dataflows to Manipulate Columns
A new view (pictured above) was recently spotted recently “in the wild” in Power BI dataflows (credit for the find: Dave Rujiter). I can’t find anything about it in the… Read more »
Third-Party Tools to Ease Power BI Development and Increase Analyst Productivity
While some cloud BI tools such as Amazon QuickSight do all their authoring in the browser, Microsoft chose to develop a dedicated client creatively named Power BI Desktop. Its initial… Read more »
Spreadsheets Get Smarter About Structured Data, At A Steep Price
I find it interesting that Microsoft and Google have chosen to gate their latest data-driven improvements to their spreadsheets behind their most expensive enterprise licenses. These new features are great,… Read more »