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
Hins_Hong
New Member

怎样可以调用EXCEL数据后,发布BI后不刷新这个EXCEL数据

在power bi desktop 中已经把power query 中Table的包含在报备刷新中去掉勾选,为什么发布到power bi online后网关刷新报告的时候依然刷新此Table

In the power bi desktop, I have already unchecked the "Include Table in report refresh" in the power query, but why does the gateway still refresh this Table when it refreshes the report after publishing it to power bi online?

1 ACCEPTED SOLUTION
hackcrr
Super User
Super User

Hi, @Hins_Hong 

Unlike Power BI Desktop's local refresh, Power BI Online Services has its own refresh logic and settings. In Power BI Online Services, you can set the refresh schedule for a dataset, which usually involves the entire dataset, not just a specific table in Power Query. So even if you cancel the refresh of a table in Power Query, if the dataset has a refresh schedule set, then the entire dataset (including that table) may be refreshed.

Here are the possible approaches at the moment:
Approach 1: If your data is processed through a data stream, you can control which data is refreshed at the data stream level. Adjust the data stream's refresh settings to ensure that tables or data you do not want refreshed are not included.
Method 2:
If you have advanced workspace permissions and the dataset supports XMLA endpoints, you can use the XMLA command to manipulate the dataset directly. With the XMLA command, you have finer control over which tables are updated on refresh.

 

 

hackcrr

If this post helps, then please consider Accept it as the solution and kudos to this post to help the other members find it more quickly

View solution in original post

2 REPLIES 2
hackcrr
Super User
Super User

Hi, @Hins_Hong 

Unlike Power BI Desktop's local refresh, Power BI Online Services has its own refresh logic and settings. In Power BI Online Services, you can set the refresh schedule for a dataset, which usually involves the entire dataset, not just a specific table in Power Query. So even if you cancel the refresh of a table in Power Query, if the dataset has a refresh schedule set, then the entire dataset (including that table) may be refreshed.

Here are the possible approaches at the moment:
Approach 1: If your data is processed through a data stream, you can control which data is refreshed at the data stream level. Adjust the data stream's refresh settings to ensure that tables or data you do not want refreshed are not included.
Method 2:
If you have advanced workspace permissions and the dataset supports XMLA endpoints, you can use the XMLA command to manipulate the dataset directly. With the XMLA command, you have finer control over which tables are updated on refresh.

 

 

hackcrr

If this post helps, then please consider Accept it as the solution and kudos to this post to help the other members find it more quickly

lbendlin
Super User
Super User

If the table if part of a lineage (ie other tables depend on it) then your exclude request will be ignored.

Helpful resources

Announcements
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!

Jan NL Carousel

Fabric Community Update - January 2025

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

Top Kudoed Authors