Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
在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?
Solved! Go to 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
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
If the table if part of a lineage (ie other tables depend on it) then your exclude request will be ignored.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.