by Chris Webb | Jul 16, 2018 | Chris Webb
Troubleshooting Power Query performance issues in Power BI and Excel can be difficult because it’s a bit of a black box: there’s nothing in the UI to tell you what’s going on inside the Power Query engine and the diagnostic logs are very difficult to interpret. With...
by Chris Webb | Jul 9, 2018 | Chris Webb
It’s very common that you need to combine data from multiple worksheets in the same Excel workbook when you’re using Power BI or Power Query/Get&Transform in Excel. Indeed a lot of people have blogged about how to solve this problem, but none of the solutions...
by Chris Webb | Jul 3, 2018 | Chris Webb
Following on from my post the other week about the new RowsetSerializationLimit server property, I thought it would be a good idea to write about why the new IsAvailableInMDX property (announced in the same blog post) is so important. In fact, I would say that...
by Chris Webb | Jun 27, 2018 | Chris Webb
In the June 2018 release of Power BI Desktop there were a number of improvements made to the way the Power Query engine handles OData data sources. You can read about them here: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-june-2018-feature-summary/#oData...
by Chris Webb | Jun 21, 2018 | Chris Webb
The recent blog post on the Analysis Services team blog about new memory options contained information about some very interesting functionality that has just been added. The first of the new features I decided to try was the RowsetSerializationLimit server property,...
by Chris Webb | Jun 15, 2018 | Chris Webb
The other day I discovered something new (at least to me) while writing the DAX for a measure in Power BI Desktop: when you insert a new line in your DAX expression using SHIFT-ENTER it also auto-indents the code. I asked a few people if this was new because I was...
