Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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!
This is the easiest way I have found. This assumes you have a SQL DB Connection of some type.
Thanks For your Comment - But Its not Working and Giving Error Like " The Connect Live Option is Disabled Because It already Contains Data From Another Source . But My File Is not having Any Data .
Then you are doing something wrong. I just followed my own directions, and it worked fine. I just downloaded the latest version of Power BI as of today (June 30, 2023). That error sounds like you might be working with an older version of PowerBI Desktop that did not allow mixed datasets.
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?
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
I am able to do it just fine following the directions. The issue is the underlying metadata of the report. If you are trying to take a completely different report, and then point it over at a Dataset in the service, no, that will probably not work. If it does, the measures etc would all need to be re-written.
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
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
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.
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.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
105 | |
99 | |
98 | |
38 | |
37 |
User | Count |
---|---|
152 | |
120 | |
73 | |
72 | |
63 |