Forum Discussion
Helper IIIReferenced query not being updated
Microsoft EmployeeHi Matthias93,
This may be the expected behavior currently. Below is the response from Product team in this thread:
The current behavior is By Design. The "Do no include in refresh" applies only to a specific table; it does not exclude downstream tables. Often users will have a "base query" (e.g. "All Customers") that they do not want to load; however, they may want to nonetheless load downstream queries (e.g. "North American Customers").
In addition, here is also a similar thread in which a workaround is mentioned. Could you go to check if it helps in your scenario? :smileyhappy:
Regards
Helper IIII think this scenario is a bit different, but let me explain to you in more detail what I'm doing and what I'm trying to achieve:
I disbled the refresh of the referenced query. My idea was to take in raw data from the SharePoint list in query A, then reference to query A in query B where I actually do all of the operations on my data. Since I'm expanding values in my query B, this tends to slow refresh time down by a lot (times 7). For that reason I figured I could disbale the refresh of query B since it takes query A as a starting point. I'm updating query A so query B should automatically follow. (in my reasoning).
Regards,
Matt
- v-ljerr-msft
Hi Matthias93,
Yes, I have noticed that. In the other scenario, they disable refresh of query A (instead of query B in your scenario).
Based on my understanding, currently, the "Do not include in refresh" will and applies only to the specific table, no matter if it is referring another table. Or both scenarios could work as expected. So I would suggest you submit your requirement on Power BI Ideas to improve Power BI on this feature. :smileyhappy:
Regards