Forum Discussion

SimonGrams's avatar
SimonGrams
Icon for Helper I rankHelper I
8 years ago
Solved

Edit measure-paths for whole project

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

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    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.

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    8 years ago

    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.