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: ...
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
Super User
Super Userthat'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.