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?
This is the easiest way I have found. This assumes you have a SQL DB Connection of some type.
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.
Hi, Was anyone able to reconnect existing SQL database dashboard to Power BI Service?
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.
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.
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
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.
In theory, follow this procedure:
@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.
Find out more about the May 2023 update.
Share your Data Story with the Community in the Data Stories Gallery.