Forum Discussion
Disabling "Include in Report Refresh": Bug or feature?
When disabling "Include in Report Refresh" in a "standalone" query, it behaves as I would expect it: The data will not be refreshed when I refresh the report.
But on the other hand, if I reference this query with another query, these data will be refreshed and passed on to the referencing query.
I didn't expect this kind of behaviour, so was wondering if this is intended behaviour or a bug that will be removed in the future?
11 Replies
Hi ImkeF,
I test on Version: 2.40.4554.463 64-bit (October 2016), but I can't reproduce your issue.
Steps:
Source Table:
Reference this query and disable original table's "Include in Report Refresh".
Save and return to report, modify the source data(excel) and refresh.
Result: The referenced table has been changed, original table not refreshed.Open the query editor and I find these query not changed.
Use refresh preview button to refresh the reference table, but original table still not changed.
Regards,
Xiaoxin Sheng
Thank you!
I've experiencing the same behaviour. The result, that the referencing query is refreshing the data is the issue I'm having with it:
When I freeze my source-table, I would have liked this freezed content to be passed onto the following queries and not the refreshing ones. (At least as long as the incremental load isn't implemented in PBI)
Therefore my question: Bug or feature?
Hi ImkeF,
I will report this to Microsoft. (In my opinion, it more like a issue instead of a feature.)
Regards,
Xiaoxin Sheng
- Hi - I'm having the same problem. It's extremely frustrating as we're spending a lot of time loading data from a pretty slow system that we know hasn't changed. Did you find a workaround?
No, unfortunately not. Pls vote for this feature!0
