Connection/ Dataset directory change

[RilwanFlame]

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. 

[PaulDBrown · Accepted solution]

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!

[PaulDBrown]

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

[RilwanFlame]

Thank you for your response. 

That i did, which looks good on the power query but what about the DAX and measures and all other design done ? 

Does that mean iwill have to redo them manually ?

Thank you

[PaulDBrown · Accepted solution]

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!

[PaulDBrown · Accepted solution]

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!