Increasing compression in Power BI and Analysis Services – Unplugged #15
After you apply all the best practices to improve compression in Power BI, you can play with advanced settings to increase it further, even though this can affect certain features.
Explore how to manipulate Encoding Hint and Available In MDX properties for columns in imported tables.
Note: VertiPaq is the storage engine used when you import data. The difference between formula engine and storage engine is explained in this video: https://www.sqlbi.com/tv/formula-engine-and-storage-engine-in-dax/?aff=yt
Learn more about DAX and Tabular Optimization in the Optimizing DAX video course: https://www.sqlbi.com/p/optimizing-dax-video-course/?aff=yt