Forum Discussion
Bug: "Include in report refresh" doesn't work with appended queries
Use case:
1. I create the 1st dataset with historical data 'DoNotRefreshMe', that I never want to refresh again.
2. I create the 2nd dataset with current data 'RefreshMe', that I want to include in the report refresh.
3. I append the 1st and the 2nd datasets, expecting that only the second would be refreshed (either in Desktop or in the Service).
Bug: all appended datasets are being refreshed regardless of the property "Include in report refresh".
Expected behaviour: during the report refresh, only the 2nd dataset 'RefreshMe' should be refreshed and then appended to the 1st dataset (which stays as-is).
2 Replies
v-yuta-msftCommunity Support
Anonymous ,
So based on your description, "dataset" means different data source or different queries, right? "Include in report refresh" only works in the report view of power bi desktop. The power bi service will refresh the whole dataset(one dataset can contains multiple data sources or queries) regardless of "Include in report refresh option".
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Yes, you are right. Let's clarify this.
'Include in report refresh' is the property of the query level.
I expect that when I create a query, click on it and disable 'Include in report refresh', it will not be refreshed ever.
It will not be refreshed in PBI Desktop,
It will not be refreshed in PBI Service,
It will not be refreshed within more complex query, even if other refreshable queries are appended.I understand that currently this is a Desktop feature only, and I would love this to be a Desktop/Service feature.
But if two queries are appended into a new one, than the 'Include in report refresh' doen't work,
and the Desktop refreshes everything regardless of this property.
So this is a bug.
Thanks!