Forum Discussion
hello_MTC
4 years agoHelper III
Server change for same existing report
Hello guys, I have created visualization in Power Bi desktop with the connection of MySQL workbench. I want all the pages, tiles and filters unchanged if I want to change server from MySQL. E.g...
- 4 years ago
Open Power Query and then open the Advanced Editor. You can change the server details in there without changing any of the subsequent steps and all of your visuals will be unaffected
johnt75
4 years agoSuper User
I don't think so, I'm afraid it will be a manual process to do each one in each file. If you anticipate having to do it again in the future you could store the connection properties in variables and then refer to the variables within the queries, but you would still need to go through all the files manually to set that up
hello_MTC
4 years agoHelper III
Ok, Your help is appriciable.