Forum Discussion
Incremental Refresh is slower than a normal refresh...
I set up incremental refresh on a dataset with about 3million records. I set the incremental refresh to work on 1 of the 18 months in the dataset. Everything works, but it actually takes longer to ...
Hi Team,
I use Power BI premiuim and and after implementing incrimental refresh the refresh takes more time than normal refresh.
i need to store 2 month data ( current + last month) and refresh only current month data.
daily insert will be approax : 6 lakhs records. can you suggest me what needs to be done to get refresh faster
Hi there
What you need to ensure is how many steps you have in the Power Query Editor which could consume time.
Also make sure that your model is using a star schema which make everything efficient.
Check to make sure your internet connection is fast to move the data if from On-Premise?
And finally make sure that there is enough CPU and memory for the incremental refresh to complete when refreshing.
What you need to ensure is how many steps you have in the Power Query Editor which could consume time.
Also make sure that your model is using a star schema which make everything efficient.
Check to make sure your internet connection is fast to move the data if from On-Premise?
And finally make sure that there is enough CPU and memory for the incremental refresh to complete when refreshing.