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

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.  

    • current_thing's avatar
      current_thing
      Frequent Visitor
      2 years ago

      My other idea was to convert the static csv import into permanent table. Meaning that it will no longer be connected to CSV file. Then using DAX expression of Union, I can combine the pemanent table and static CSV file. Do you have suggestions how to go about converting CSV table into permanent table? Thanks!

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

        that's a bad idea.  The DAX UNION will double the amount of memory your semantic model needs, for no good reason.  Don't do that.

         

        Static CSVs are the least bad option.