PowerBI Service Data Set Refresh Now - Whole Data Set or just the modified Data?

[Anonymous]

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:

1. SPO: Open the data table and make the change.
2. PBID: Open PBID which takes up to 5 minutes.
3. PBID: Refresh the queries that relate to the modified data table which again takes up to 5 minutes.
4. PBID: Save which takes up to 5 minutes, sometimes longer.
5. PBIS: Refresh the entire data model: About 30 minutes.
6. 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?

[v-lili6-msft · Accepted solution]

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