Non-Obvious Functional Behavior in Power BI Deployment Pipelines
I’ve been spending time lately trying to get a deployment pipeline to work for one of my clients and ran into a couple of non-intuitive limitations that I didn’t expect,… Read more »
Category: Power BI
Limitations of On Premises SQL Sources with the Microsoft Power Platform
On the surface it may look like Microsoft’s data gateway provides an even playing field between IaaS and PaaS approaches with regards to SQL hosting, i.e. you can run your… Read more »
How to Get DAX Query Results Out of Power BI… Without Writing Any DAX or Code
Power BI’s DAX language is often described as “simple but not easy.” While visuals such as tables and matrices generate a lot of DAX behind the scenes, such as subtotals… Read more »
Power BI Dataset vs. Dataflow vs. Datamart vs. Dataverse vs. SQL Server vs. Synapse – Are You Confused Just Yet?
With the preview launch of Power BI datamarts in May 2022, there is yet another data entity to contend with in the Power BI ecosystem. I plan to update this… Read more »
Getting Started with the Dataverse API in Postman
This entry fills in the gaps of Microsoft’s official documentation as I had to go through a fair amount of trial and error to get things going. It assumes general… Read more »
Which Languages Should You Learn as a Power BI Developer?
Data-centric jobs are sitting by definition at the intersection of business and technology, and that affects who performs these jobs, their tools, and workflows. Traditionally data analysts tend to be… Read more »
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 »
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 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 »