Forum Discussion

gazumpt's avatar
gazumpt
Frequent Visitor
9 years ago

MYSQL connection - changing database source requires M query

Hi,   I am developing Power BI reports off a Dev MYSQL Database and now want to point the reports at the UAT database. Both databases have the same tables/structure and are hosted on the same serve...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi gazumpt,

In  your scenario, you can create parameter for database names in Query Editor as shown in the following screenshot.


After you create reports for your Dev MySQL Database, you are able to switch the database to UAT database by changing the parameters’ values.


For more details about creating parameter in Power BI Desktop, please review the following blog:
http://biinsight.com/power-bi-desktop-query-parameters-part-1/


Another method is to paste the codes of Advanced Editor to Text file, press Ctrl+H, replace "Dev" with "UAT" in the codes, then copy the codes back to Advanced Editor.

Thanks,
Lydia Zhang