by Chris Webb | Apr 6, 2020 | Chris Webb
One of the most common errors you’ll see when working with Power Query in Power BI or Excel is this: Expression.Error: The key didn’t match any rows in the table This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/Hq2tSS93JYk/. The author...
by Chris Webb | Mar 31, 2020 | Chris Webb
A few weeks ago I showed how XMLA Endpoints allow you to connect SQL Server Profiler to Power BI Premium. As well as looking at query execution times this also means you can see in more detail what happens when a dataset is refreshed, for example so you can find out...
by Chris Webb | Mar 23, 2020 | Chris Webb
A very quick performance tip: do you have users consuming Power BI reports with Internet Explorer 11 and an older Windows OS like Windows 8.1 or Windows 7? If so, their reports are likely to be slower because over the last few months some important performance...
by Chris Webb | Mar 16, 2020 | Chris Webb
Back in 2018, when I wrote a detailed post on how to create nested display folders for measures in Power BI, I mentioned that unlike in Analysis Services it was not possible to make a Power BI measure appear in two or more folders simultaneously. The other day on...
by Chris Webb | Mar 9, 2020 | Chris Webb
In my last post I showed how to connect SQL Server Profiler up to a Power BI Premium dataset but I didn’t give you any examples of why this might be useful. In this post I’ll show you how you can use a Profiler trace to visualise all the queries run by a Power BI...
by Chris Webb | Mar 2, 2020 | Chris Webb
Back in December when I wrote a series of posts on testing the performance of Power BI reports in the browser, I mentioned that it was important to test in the browser because some aspects of the performance of a report may be different there compared to in Power BI...
