March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi,
We are currently using the Power BI Services for over a year and we are noticing that our dataset are piling up because we use the SSAS Live connection instead of the Power BI Online connector.
Is there a way to change the connection in Power BI Desktop from SSAS to an Power BI Online connection? The only other option is rebuilding all the reports to the Power BI Online connection, but that would mean rebuilding 50+ reports...
With kind regards,
Daan Damhuis
Hi guys,
Did any of you find a solution for this?
HI,
I've used the Business Ops from Powerbi.tips. It contains a program that's called "Hot Swap Connections" by Steve Campbell.
Hi,
Just did this yesterday as well, and it works wonders.
Here are the steps :
1. Be sure that the Preview feature : “DirectQuery for Power BI datasets and Analysis Services” is activated.
Go to File --> Options and settings --> Options --> Preview features
2. Click on “Make changes to this model” (right corner where you see your data connection)
3. A pop up will prompt then Select “Add a local model”
4. Go to Transform Data -- > Data source settings
5. Delete your SSAS source by clicking on “Delete…”
6. A yellow ribbon will appear then Select “Apply changes”
7. Your dataset from SSAS is now all removed. Now you want to establish a connection to your Power BI dataset. Select Get Data --> Power BI dataset. You are now connected Live on your Power BI Dataset.
Hope it helps
Cheers!
ventriloc.ca
@daandamhuis, not sure if you found a solution, but the following method worked for us (assuming the powerbi dataset exists)
it takes about 1 minute, but feel free to tell your manager that you had to recreate the 50 reports.
Hi - I faced this same issue and found a solution this morning.
We also have the same problem. Without the ability to copy content from one report to another, we would have to recreate all our reports (which is way too time consuming to justify doing).
Yes that exactly it. Is there a uservoice thing for it?
Hi @daandamhuis
Did you try to change your data source ?
Go to File -> Options and settings -> Data source settings >Right click data sources and change source
- Quentin
Nope can I only change the connection within SSAS , but I can't change it to Power BI Online connection.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
93 | |
84 | |
82 | |
74 | |
49 |
User | Count |
---|---|
160 | |
144 | |
103 | |
74 | |
57 |