Refresh a single table that has incremental refresh enabled in dataset without updating other tables

[Anonymous]

Hi

I have a Power BI dataset with a few tables in it - one with incremental refresh (daily data) and the rest without incremental refresh (historical data).

I am trying to trigger a refresh on only the table with incremental refresh enabled, not for a full load but just a normal incremental refresh. The kind that Power BI service would do if i hit refresh in the UI (create the latest partition and load/reload data per policy).

I know I can use SQL Server Mgmt Studio to Process Full ("type": "full") on a single table to load all data ignoring the incremental refresh. I also know that I can view individual existing partitions and process those too. And when I try Process Default ("type": "automatic"), nothing seems to happen.

How can I trigger a normal incremental refresh on a single table without forcing a refresh on other tables that are not setup to be refreshed incrementally?

Appreciate any assistance!

[Anonymous · Accepted solution]

I was able to do this by also passing the parameter "applyRefreshPolicy": true along with "type": "full" referring the link below.

https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-xmla 

[jeffshieldsdev]

EDIT: Not possible in shared capacity, but is possible in Power BI Premium with XMLA endpoint enabled.

Not possible--all tables in the dataset are refreshed.

You'll have to move your queries to separate dataflows for more granular control over individual table refreshes.

[Anonymous]

Hey, it looks like I am able to do what I asked about using the TMSL parameter "applyRefreshPolicy": true via XMLA against a single table. Taking a quick look, it seems to be working, is there a reason you say it's not possible?

Here is the resource I referred

https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-xmla#override-incremental...

[jeffshieldsdev]

Not possible in shared capacity, but yes you're right, is possible with Power BI Premium and XMLA end-point enabled.

[iBusinessBI]

Is it possible with PPU?

[Anonymous]

I should have mentioned I am on Premium. Thanks!

[NimaiAhluwalia]

Hello @Anonymous 

As far I have understood your problem what possible solution I can prefer is that you can disable the refresh option on the specified tables in the Power Query ( Transform Data ).

IF MY SOLUTION HELPED YOU PLEASE DO HIT A LIKE AND ACCEPT IT AS A SOLUTION IF IT SOLVES YOUR ERROR!

Regards,

Nimai Ahluwalia

[jeffshieldsdev]

"Include in report refresh" only applies to the behavior of the Refresh button on the ribbon in Power BI Desktop.

Solved: Re: Disabling "Include in report refresh" not work... - Microsoft Power BI Community

[Anonymous]

Wow, thanks for mentioning this!

[Anonymous]

Those tables would still need to be occasionally refreshed, I think I figured out how to do what I want via XMLA but thanks for the suggestion. Might come in handy just in case!