Forum Discussion
Switch a data source from SQL database to Power BI Service (live connection) on existing dashboard?
Hi, Is is possible to switch a data source from an SQL database to Power BI Service (live connection) on an existing dashboard? I want to use the same data set but switch to live connection witho...
In theory, follow this procedure:
- Create a new PBIX file and connect it to the Power BI Service dataset that you want.
- In Query Editor, go to Advanced Editor and copy the Source line
- Copy your existing PBIX file to a new file
- Go into the Query Editor and the Advanced Editor and replace the Source line of your query.
Greg_Deckler but I cannot access the Query Editor once I chose the Power BI Service as data source, right?
Hmm, that's a fair point sophie63. If your original PBIX file connected to a live SQL Server, you might be able to do this.
- Create new PBIX file and connect to your dataset in the Service
- Save the PBIX file and then copy it to a .ZIP file
- Open the ZIP file and copy the "Connections" file
- Backup your original PBIX file or otherwise ensure it is safe and will not get overwritten
- Copy your original PBIX file to a .ZIP file with a rename for good measure -> copy MyFile.pbix MyFile1.zip
- Open this .ZIP file and replace the "Connections" file with the one you copied
- Rename this copied .ZIP file back to .PBIX