Edit measure-paths for whole project

[SimonGrams]

Hello everyone,

a collegue of mine created a PowerBI report based on an Excel spreadsheet.

This report includes many calculated measures and columns.

Now he wants to change his data source - from the Excel spreadsheet to an Azure SQL database.

The spreadsheet was an extract of the database, so all metrics, etc are the same.

Is it possible to change the 'paths' of all measures at once?

It would take a lot of time to change every single measure by itself

Thanks in advance

[v-jiascu-msft]

Hi @SimonGrams,

Could you please mark the proper answer as solution?

Best Regards!
Dale

[Greg_Deckler · Accepted solution]

You should be able to just change the Source line in the Advanced Editor. Create a new PBIX. Connect to Azure SQL Database. Go into Advanced Editor and copy the Source line. Go into your other report, go to Query Editor, Advanced Editor and replace Source line.