Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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!
Solved! Go to 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
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
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.
Is it possible with PPU?
I should have mentioned I am on Premium. Thanks!
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
Wow, thanks for mentioning this!
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!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
48 | |
28 | |
20 | |
20 | |
19 |
User | Count |
---|---|
51 | |
51 | |
26 | |
25 | |
20 |