cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sophie63
Helper I
Helper I

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 without having to recreate the whole dashboard. Is it supported by Power BI?

 

Thanks!

9 REPLIES 9
dbhudia
Frequent Visitor

Anyone found a resolution to this ? Everyone starts with a Report + SQL Connected datasource initially then eventually evolves to PowerBI Dataset. It seems silly not to have a way to go from A to B without the need to totally recreate the original report. 

Majidbhatti
Advocate IV
Advocate IV

Hi, Was anyone able to reconnect existing SQL database dashboard to Power BI Service?

 

 

Anonymous
Not applicable

Hi,

 

I just want to confirm it is not possible to Change the datasource from SQL data source to a Power BI Service live connection dataset.

 

Cheers

v-shex-msft
Community Support
Community Support

Hi @sophie63,

 

I'd like to suggest you publish origianl report to power bi service, then create a new report with power bi service as datasource. It will change to live connection mode, but I haven't found a solution to keep original visuals.

 

BTW, I also test with smoupre's workaround, but it seems not works.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Anonymous
Not applicable

Can I get confirmation that you still cant switch from a sql server connection to a Power BI Service live dataset connection in Power BI

 

 

cheers

omrdmr
Helper I
Helper I

Hi @sophie63,

 

Unfortunately, if you would like to get data from a live data set in your PBI service, you will not be able to load any other data sources in your PBI app. Whatever you need have to be in the live data set.

 

Regards.

Greg_Deckler
Super User
Super User

In theory, follow this procedure:

 

  1. Create a new PBIX file and connect it to the Power BI Service dataset that you want.
  2. In Query Editor, go to Advanced Editor and copy the Source line
  3. Copy your existing PBIX file to a new file
  4. Go into the Query Editor and the Advanced Editor and replace the Source line of your query.

 


@ me in replies or I'll lose your thread!!!
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Learn Power BI 2nd Edition

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

 

 

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

@ me in replies or I'll lose your thread!!!
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Learn Power BI 2nd Edition

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

Power BI Dev Camp Session 22 with aka link 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!