Michael Milirud on 04 Jul 2020 12:58:45
Unchecking "Include in report refresh" is supposed to stop refreshing the query, yet if you reference that query in another query (something you'd do if you wanted to hold a local cache of the static data *not* to be refreshed), it disregards the setting and refreshes it again. Clearly a bug. Please fix.
Here's another mention of this from https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/: "...unintuitive behaviour of queries which have been set to “Don’t include in Report Refresh”: As a standalone-query, they will behave as expected and not refresh. But once you reference them by a separate query or within an append-operation, they will refresh their results. So beware of this potential trap!..."
- Comments (1)
RE: "Include in report refresh" doesn't work when query is referenced
Looks like it was also raised here: https://community.powerbi.com/t5/Issues/Bug-in-quot-Don-t-include-in-Report-Refresh-quot/idc-p/112237#M1627 and resolved as By Design, but then how do you cache static result in PQ so you don't hit the source every single time? It's something I want to load once and then merge with other dynamically refreshing tables as needed.
A simple fix to this would be to have PQ convert result of a query marked not to be refreshed to a static table, similar to what we can do with Enter Data option: Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText(...