by Chris Webb | Jul 12, 2020 | Chris Webb
Do you have Analysis Services Multidimensional cubes in production? Although I know it’s a long time since I last posted any Multidimensional/MDX content here I hope I still have some readers who do. If so, then you may be able to help me. The reason I ask is that in...
by Chris Webb | Jul 5, 2020 | Chris Webb
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...
by Chris Webb | Jun 28, 2020 | Chris Webb
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...
by Chris Webb | Jun 21, 2020 | Chris Webb
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...
by Chris Webb | Jun 14, 2020 | Chris Webb
In the previous post in this series I showed how you can use the Table.Join function and the SortMerge algorithm to get much better performance for merge operations in Power Query – but only if your data is sorted. But what if your data isn’t sorted? Can those other...
by Chris Webb | Jun 7, 2020 | Chris Webb
In the last two posts in this series I showed how removing columns from the tables used in a Power Query merge operation can improve refresh performance. In this post I’ll show you a different trick that – when you can use it – can give you an equally significant...
