Back in 2016 I wrote the following blog post about changes to the way Excel 365 generated MDX queries for PivotTables connected to Analysis Services, Power Pivot/the Excel Data Model and Power BI datasets: https://blog.crossjoin.co.uk/2016/07/08/excel-2016-pivottable-mdx-changes-lead-to-big-query-performance-gains/ I know it sounds boring and not something you need to worry about but trust me, this is important – […]

über Excel PivotTable Query Performance With Analysis Services, Power Pivot And Power BI (Revisited) — Chris Webb’s BI Blog

This is still one of the most common dataflows questions: what’s the difference between Power BI dataflows and Power BI datasets? For the last year I have resisted tackling this question head-on. This isn’t because it’s a bad or „dumb“ question. Just the opposite – this is a very simple question, and the simpler a […]

über Power BIte: Dataflows vs. datasets — BI Polar

If you’re a frequent reader of this blog, or a frequent user of Power BI dataflows, you probably know these things already: Power BI dataflows are workspace-level objects in the Power BI service that enable data reuse through self-service data preparation. Power BI dataflows store data in the CDM folder format in Azure storage. CDM […]

über Importing model.json to create a new dataflow — BI Polar

 

The reaction to this recent post on lineage and Power BI dataflows highlighted how important lineage is for Power BI[1]. Although (as this post shows) there are lineage user experiences in place for dataflows today, and experiences coming for all artifacts in a workspace. Even with these new experiences, there will still be times when […]

über Governing Power BI just got a little easier — BI Polar

When asked what content our blog readers and video viewers would like to see more of, the most requested topic is: „Industry Best Practices“. With that in mind we will be starting a series of Blog posts and Webinars by our MVPs highlighting work they have done. The first in this series is by Ike […]

über Creating Updateable Power BI Reports with PowerApps by Ike Ellis — Sterlings