CODEWITHSUNDEEP
powerbi
Chen Hirsh
Chen Hirsh

Reputation: 1400

Is there a way to full load once after setting incremental refresh in powerbi?

I set up incremental refresh in powerBI, and it loaded all the history to the service, and now only refreshes the last data every time, as expected. I need to reload once all the history, because of changes made to historical data. Is there a way to do so?

If I republish my dataset from PowerBI desktop to the service, the data will be reloaded fully. Is there a simpler solution?

Upvotes: 1

Views: 5324

Answers (2)

David Browne - Microsoft
David Browne - Microsoft

Reputation: 89361

If I republish my dataset from PowerBI desktop to the service, the data will be reloaded fully. Is there a simpler solution?

Simpler, no. But you can force a full refresh with the Rest API.

applyRefreshPolicy Boolean true

If an incremental refresh policy is defined, applyRefreshPolicy will determine if the policy is applied or not. If the policy isn't applied, a process full operation will leave partition definitions unchanged and all partitions in the table will be fully refreshed. Modes are true or false.

Upvotes: 1

Dani U
Dani U

Reputation: 434

If your model is NOT in a Premium workspace, republishing is your only option.

If your model is published to a Premium workspace, you can manage the underlying data through the XMLA endpoint. You have to have that set up to be writable in your Power BI Admin settings. Once it's open, you can manage IR models with SQL Server Management Studio (MS doc here). There are also some third-party tools. Of these, Tabular Editor is the best. This is a video from Guy in a Cube that will get you started with TE.

If you have Premium, I highly recommend setting up all your IR tables as Dataflows. That separates the IR from your report, and makes managing IR much simpler in the long run. IR Dataflows are not available without Premium.

Upvotes: 3

Related Questions