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: ...
lbendlin
Super User
Super Useryes, 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.
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
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.