Debugging DAX – GuyInACube Video
Last time I was in Seattle, I was lucky enough to do a short video with the famous GuyInACube showing a useful technique I use when debugging DAX in Power BI. I hope you find it useful.
Category: Optimise
DAX Fusion
Introduction: Around 2014, an enhancement was made to the DAX engine designed to help improve query speed. The enhancement, called DAX Fusion, looks to reduce the number of storage engine scans needed to satisfy queries, by combining similar scans where possible. This optimisation feature exists in Power BI, so can be used to help speed … Continue reading DAX Fusion
Speed up Power BI reports using columns
Did you know, in some cases, it is possible to add columns to your model to speed up the DAX used behind visuals to make them as much as 100 times faster? The PBIX helper file for this article can be downloaded here. I have come across this scenario a few times recently, so thought … Continue reading Speed up Power BI reports using columns