Forum Discussion

sophie63's avatar
sophie63
Helper I
9 years ago

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...
Need Help
sophie63's avatar
sophie63
Helper I
9 years ago

Greg_Deckler   but I cannot access the Query Editor once I chose the Power BI Service as data source, right?

 

 

Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

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.

 

  1. Create new PBIX file and connect to your dataset in the Service
  2. Save the PBIX file and then copy it to a .ZIP file
  3. Open the ZIP file and copy the "Connections" file
  4. Backup your original PBIX file or otherwise ensure it is safe and will not get overwritten
  5. Copy your original PBIX file to a .ZIP file with a rename for good measure -> copy MyFile.pbix MyFile1.zip
  6. Open this .ZIP file and replace the "Connections" file with the one you copied
  7. Rename this copied .ZIP file back to .PBIX