Forum Discussion
Connection/ Dataset directory change
Hi All-
Hoping to get help on how to change my source directory from my local system location to Azure Datalake Gen 2 and to have every changes, calculating measures done on the datasource of my local system directory remain the same when changed to datalake directory.
I hope i make sense
Thank you.
If the columns, table names and the model setup are exactly as they are in the original, all DAX and measures will work, since they are built based on tables and columns.
Whatever you do, try all this out on a copy of the original PBIX file just in case!
If the columns and table names are exactly as they are in the original, all DAX and measures will work, since they are built based on tables and columns.
Whatever you do, try all this out on a copy of the original PBIX file just in case!
4 Replies
Create a new query(ies) (in a new PBIX file) to the new source and edit the column names and tables to be exaclty as you have them in the current queries. You can then copy the M-code for this/these queries and paste them into the old quiries' advanced editor
If the columns, table names and the model setup are exactly as they are in the original, all DAX and measures will work, since they are built based on tables and columns.
Whatever you do, try all this out on a copy of the original PBIX file just in case!