Forum Discussion
Sampath_Santosh
2 years agoRegular Visitor
Analize in Excel performance is slow.
Hello team, I hope you are all doing well. Currently, we are facing a challenge related to our global sales data, which contains a very detailed level of information. We have approximately 130 milli...
lbendlin
2 years agoSuper User
Examine the queries that are run against your datasets. Sometimes people are overly inventive and add Cube Functions in their Excel files (we had scenarios where they had a full cube in each of the 10000 cells of a sheet/table)
Migrate your users to "Live connection" exports to Excel - those use DAX queries and are much faster.