Forum Discussion

KasperJ90's avatar
KasperJ90
Icon for Helper III rankHelper III
3 years ago

Excel file running Power BI dataset slow performance

Hi, I have build an Excel file for controlling purposes based on my organizations Power BI dataset. People are using slicers I included in the file as standard but also redefining the Pivot tables...
Need Help
Show and Tell
Tips and Tricks
Tsanka's avatar
Tsanka
Icon for Kudo Collector rankKudo Collector
3 years ago

Hi KasperJ90 ,

 

I have exactly the same case. The MDX queries from Excel to the Azure Analysis Service (live connection) are slow and sometimes raise errors. The connected Excel tables are based on DAX and have a good performance, however they lack flexibility. Have you managed to find a solution?

 

Thanks

Tsanka