Optimise Archives - Page 6 of 6 - Phil Seamark on DAX

DAX Fusion

August 5, 2019August 5, 201911 Comments

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

July 8, 2019July 8, 20196 Comments

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