Forum Discussion
Edit data set that has incremental refresh enabled
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.
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.
- Ahh apologies for that I forgot that you were on Power BI Premium.
Yes this can be done with either the upcoming ALM toolkit or Tabular Editor and make the changes.
You would then connect to the XMLA end point (After enabling the Read/Write functionality)
GilbertQ Can you please elaborate on steps how a power Bi premium user can download the data model which has incremental refresh applied on it... with the the help of Tabular Editor...
Hi Anonymous
you cannot download the data model once incremental refresh has occured. The only thing I can think of is to backup the data model if the data model is in PPU or Premium?