Forum Discussion
Transitioning a Power BI Project from Static Files to Auto-Updated Data Source
Hi _Ester_
My lazy brain wants to choose option 2. Create the new connection and then copy all the M steps into the Advanced editor of the new connection. The issue is if the names change again you'd need to go through the process again. I think it will be a combination of this to do the M transfer and then some of option 1 to change the DAX measures.
However option 1 can be done easier than you might think. Or at least updating all the measures doesn't need to be so awful.
I need to update all these measure:
In the DAX queries view
Click on your measure and choose Define all measures in this model
Use Ctrl + H to open the find and replace. Enter the old name and new one:
Finally click on Update model with changes:
All your measures should now work 🙂
Hi _Ester_
My lazy brain wants to choose option 2. Create the new connection and then copy all the M steps into the Advanced editor of the new connection. The issue is if the names change again you'd need to go through the process again. I think it will be a combination of this to do the M transfer and then some of option 1 to change the DAX measures.
However option 1 can be done easier than you might think. Or at least updating all the measures doesn't need to be so awful.
I need to update all these measure:
In the DAX queries view
Click on your measure and choose Define all measures in this model
Use Ctrl + H to open the find and replace. Enter the old name and new one:
Finally click on Update model with changes:
All your measures should now work 🙂
Thanks SamWiseOwl!
I had never tried this Power BI feature before and I didn't know it could be so useful!
