Forum Discussion
PowerBI Service Data Set Refresh Now - Whole Data Set or just the modified Data?
Question: Is there any way to only up-date the modified part of the data model in PBIS?
Details and reason for question:
I have built a model in Desktop using data files stored in SharePoint online, which has been published to service and then SharePoint online. I have to update one of the tables every morning and the whole data model once a month.
If I want to change the data in one field of any of the base data tables and see that change in SharePoint, I have to:
- SPO: Open the data table and make the change.
- PBID: Open PBID which takes up to 5 minutes.
- PBID: Refresh the queries that relate to the modified data table which again takes up to 5 minutes.
- PBID: Save which takes up to 5 minutes, sometimes longer.
- PBIS: Refresh the entire data model: About 30 minutes.
- SPO: Open, refresh and check that the data has been pulled through.
So I am looking at about 45 minutes for every change...
My concern is that as I add data to the model the 45 minutes could become several hours.
Is this just the way it is or can I improve the process somehow?
hi, Anonymous
Current, It refreshes the whole date.
You could try Incremental refresh, but it needs a Power BI Premium license for now.
https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh
Best Regards,
Lin
1 Reply
- v-lili6-msft
Community Support
hi, Anonymous
Current, It refreshes the whole date.
You could try Incremental refresh, but it needs a Power BI Premium license for now.
https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh
Best Regards,
Lin