Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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:

  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?