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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

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

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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

Top Solution Authors