Forum Discussion
Prevent refresh of a table in Table.combine
Hello,
I have created a PBI file that consists of:
Book1 will consist of data that will not change. Book2 will consist of data that will change. Query2 is a union of Book1 and Book2.
Goals:
1) In Desktop view, the user will see only Query2 which I've accomplished
2) When I refresh Query2, I only want the refresh of Book2 since this will be dynamic data. How can I accomplish this? Even though I specifically set option to not refresh Book1, it still does when I refresh Query2
Hope my question is easy to understand with screenshots. Thanks!
7 Replies
- lbendlin
Super User
Even though I specifically set option to not refresh Book1, it still does when I refresh Query2That is by design. The "do not refresh" request will be ignored for queries that other queries depend upon.
Thanks for replying. Can you think of a setup that'll accomplish what I'm trying? The static dataset is HUGE, so it is cumbersome and waste of resource to refresh it.
- lbendlin
Consider using incremental refresh or other manual partition management processes.
