Forum Discussion
Solved
Power BI Dataset Live Connect, Convert from SSAS Live Connect
We have a lot of reports with Analysis Services Live Connections. We would like to convert these to Power BI Dataset Live Connections. I can not find a way to do this via the UI. What is the easiest...
- Hello
You could use this tool by the awesome people of PowerBi.tips
https://powerbi.tips/2020/08/hot-swap-report-connections-external-tools/
Excellent suggestion on tool from PowerBITips.com. I followed the code and found the steps are:
1. Add .zip to the file and open in File Explorer
2. Delete "Connections" and "Security Bindings" files in the zip archive.
3. Remove the .zip extension and open PBIX file as normal.
4. Choose Get Data from Power BI Dataset (Live)
Whilst this does work, remember if something goes wrong it is not supported my Microsoft.