Forum Discussion
Refresh takes almost an hour
Hi, everyone! I'm looking for some advice. I am trying to create a Power BI Report that uses a few sources: Great Plains (Accounting software), Business Central and also Dataflows (that pull from Business Central but also from a Cat2 Database). The refresh takes almost an hour. What is the best way to decrease this time (if there is a best way?)
Thanks for any help! One idea someone told me about was to set up an incremental refresh on the Dataflows? (ie - only pull in the new data and make the historical static?)
1. identify the component that takes the longest
https://dax.tips/2021/02/15/visualise-your-power-bi-refresh/
2. Use DAX Studio to evaluate the query plan and refactor the query.
1 Reply
- lbendlin
Super User
1. identify the component that takes the longest
https://dax.tips/2021/02/15/visualise-your-power-bi-refresh/
2. Use DAX Studio to evaluate the query plan and refactor the query.