copy a pbix to another mysql datasource

[meijndhoven]

Is it possible to copy the settings, relations and reports from an existing dataset (pbix) based on a MySql database to a new dataset that is linked to another MySql database?

[v-jiascu-msft · Accepted solution]

Hi @meijndhoven ,

Since you need a new dataset, that would be easy. Please refer to the solutions below.

1. Copy the file and change the data sources. The new data source should have the same tables and tables should have similar structures.

2. Try the Power BI template (.pbit file). Please refer to blog/deep-dive-into-query-parameters-and-power-bi-templates/.

Best Regards,