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

[Hins_Hong]

在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?

[hackcrr · Accepted solution]

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]

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