Select Page

Three Ways to Use Power BI Dataflows

Dataflows in Power BI are a really interesting capability for centralizing and reusing Power Query logic among many different PBIX files. If you’ve found yourself copying M scripts (Power Query formula language) between files, or creating a library of M scripts then...

Keeping Up with Azure Changes

Since I started focusing primarily on Microsoft BI/DW/analytics around 2005, I’ve always been happy being a generalist within that space. Fast forward to around 2017 when I started focusing predominantly on Azure. Being a generalist (still within...

FAQs About Organizing a Data Lake

This post covers several things I’ve heard or been asked recently about organizing data in a data lake. Q: Partitioning by date is common. Where should the dates go in the folder hierarchy?Almost always, you will want the dates to be at the end of the folder...