Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The 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.

Reply
Anonymous
Not applicable

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!

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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 

View solution in original post

10 REPLIES 10
Anonymous
Not applicable

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
Solution Sage
Solution Sage

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
Not applicable

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...

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?

Anonymous
Not applicable

I should have mentioned I am on Premium. Thanks!

NimaiAhluwalia
Responsive Resident
Responsive Resident

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 ).

 

PBI -include-in-report-refresh-disabled.png

 

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

Anonymous
Not applicable

Wow, thanks for mentioning this!

Anonymous
Not applicable

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!

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.