Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 in the Excel file. The issue is that it is running quite slow and "Running OLAP query" each time a new selection is made in the file.
How can I increase the performance of this Excel file?
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
Hi @Tsanka
I connect via the new feature "insert table" in Excel. I can not get all rows out I want, so I am still limited.
Maybe you can use it. See it here: https://www.youtube.com/watch?v=kIWRKdapx08&t=283s
Hi @KasperJ90 ,
There are several factors that can affect the speed and efficiency of your Excel file, such as the size and complexity of the Power BI dataset, the network latency, the gateway configuration, the data model optimization, and the Excel settings. Here are some possible ways to increase the performance of your Excel file:
For more information, please refer to these web pages:
Power BI & Large Dataset: How to improve performan... - Microsoft Fabric Community
Design refreshable reports in Excel with Power BI data - Power BI | Microsoft Learn
Connect Excel to Power BI datasets - Power BI | Microsoft Learn
Best regards,
Community Support Team_yanjiang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks you for answer.
I have a question for your first point "Only load the columns and measures that you absolutely need in your Excel PivotTables or tables". Currently I am loading the entire data model and save the Excel file in our organizations share folder. I actually only need data from my sales table, but how can I extract only this tables including the measures?
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |