Forum Discussion
Performance in Analyse in Excel
Hi, One of our old SSAS cube (Multidimentional) cube has been converted to fabric semantic model currently using F64 users need to use their old expeirence using Excel endpoint because of that w...
Power BI has to emulate MDX when running Analyze in Excel. That translation impacts performance.
Nowadays our power users have moved away from Analyze in Excel towards "Live connection" which is based on DAX queries against the Semantic Model. Even though they lose the cube access they seem to be happier.