Forum Discussion
Solved
Edit data set that has incremental refresh enabled
I built a data set and a report using PBI Desktop (March 2020). Enabled the incremental refresh in two of the tables and pusblished it to the premium capacity. In the service, I setup the refresh sch...
At least for Power BI data sets I do not agree that we have to start from the scratch because we had metadata changes. I found this document and it explains how this can be done without loosing all the historical data. I have not tried it yet but something I will definitely give a shot.
Hi there
This would happen in any scenario where there are new columns being added.
You would have to have a copy of the original PBIX, go into the PBIX and make the required changes, adding the new columns, measures, etc.
Then upload this to the Power BI Service and do a manual refresh to get the incremental refresh set up again.
In other systems such as SSAS/AAS this is how it also has always been done.
This would happen in any scenario where there are new columns being added.
You would have to have a copy of the original PBIX, go into the PBIX and make the required changes, adding the new columns, measures, etc.
Then upload this to the Power BI Service and do a manual refresh to get the incremental refresh set up again.
In other systems such as SSAS/AAS this is how it also has always been done.
At least for Power BI data sets I do not agree that we have to start from the scratch because we had metadata changes. I found this document and it explains how this can be done without loosing all the historical data. I have not tried it yet but something I will definitely give a shot.