Select Page

Why Is Power BI Running My SQL Query Twice?

When you import data from a relational database like SQL Server in Power BI you have the option of entering your own SQL query to use as a starting point: Here’s the M code for a query that does this: This post first appeared...

Naming Tables, Columns And Measures In Power BI

I see a lot of Power BI datasets in the course of my work, and as a result I see a lot of datasets that look like this: What’s wrong with this picture? Look at the names: This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/9f3ms0mOmkU/. The...

Video: Power BI Data Privacy Settings Deep Dive

Over the past year or so I’ve been delivering a presentation on the Power Query engine’s data privacy settings at various conferences and Power BI user groups, in an attempt to try to pull together all the knowledge I have on this complex topic. Luckily, when I...