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.

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        2 years ago

        yes, it requires access through the XMLA endpoint which is a premium feature too.

         

        That means your only choice is to do your own pseudo partition management (ie CSV files on a OneDrive) and accept the cost of loading all these files all the time.