Forum Discussion
Refresh a single table that has incremental refresh enabled in dataset without updating other tables
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!
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
10 Replies
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
"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
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.
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
Not possible in shared capacity, but yes you're right, is possible with Power BI Premium and XMLA end-point enabled.
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
