How to Best Edit an Incrementally Refreshed Dataset

[rbriga]

I employ an incremental refresh in some of my largest datasets.

The setup I use has no Direct Query component.

For example, The past month is incrementally refreshed as an import, and the past 3 years are archived.

This makes the daily refresh run faster with a lower strain on our resources.

Yet incrementally refreshed datasets come with disatvantages.

• One can't download the dataset to make changes.
• One can't use Power BI service to make changes

Whenever I need to make even slight changes- adding a measure or a column to the smallest dimesion table, I have to edit an older offline version, reload the entire model (can take long) and republish.

Am I missing a better way to edit incrementally refreshed datasets?

[rbriga]

Interesting.

So since I use Premium by Capacity, I can connect to the data model and make some changes. For example, I can fix measures.

Other than than, I can have the report connect to the incrementally refreshed dataset. That would make it a Direct Query connection, but I'll be able to make UI changes without reloding the entire model.

Changing the tables themselves still requires saving an offline copy, working on it and republishing. 

Thank you.

[Idrissshatila · Accepted solution]

Hello @rbriga ,

This video is very helpfull, check it out https://youtu.be/Kui_1G6kQIQ

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin