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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors