Forum Discussion

current_thing's avatar
current_thing
Frequent Visitor
2 years ago

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: ...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago
Even though I specifically set option to not refresh Book1, it still does when I refresh Query2

That is by design.  The "do not refresh"  request will be ignored for queries that other queries depend upon.

  • current_thing's avatar
    current_thing
    Frequent Visitor
    2 years ago

    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's avatar
      lbendlin
      Icon for Super User rankSuper User
      2 years ago

      Consider using incremental refresh or other manual partition management processes.

      • current_thing's avatar
        current_thing
        Frequent Visitor
        2 years ago

        I believe incremental refresh requires premium subscription, which my company won't pay for. Can you tell me more about manual partition management? Does this require premium subscription? Thanks.