Forum Discussion
Improve performace update
Hi
I have a dataset that contains a merge of 35 excel tables that come from a personal OneDrive. A few days ago it took about 5 minutes to update. It is now taking approximately 30 minutes in a premium capacity workspace. I noticed that the problem is among the search for data within OneDrive and their processing within BI. I already removed all unnecessary columns and saw that my DAX formulas are ok. What suggestion do you have for improving the performance of this report?
Hi leandro_41 ,
Are you using import mode? Because it is the best in terms of improving performance.
Please hit the thumbs up and mark it as a solution if it helps you. Thanks in advance.
Thank you for the update!
3 Replies
Hi leandro_41 ,
Are you using import mode? Because it is the best in terms of improving performance.
Please hit the thumbs up and mark it as a solution if it helps you. Thanks in advance.
Thank you for the update!
Hi leandro_41
Are you asking about improving the performance of the report or Refresh time?
Refresh time depends on many factors, Like Gateway trafic, time of the refresh, the performance of the macgine where the Gaetway is installed, size of the datset, DAX formulas eventhough you think they are ok(Like SEARCH formula is not recommended)...
