Forum Discussion
Change Connection from Power BI Service to SSAS
Hi everyone,
I was wondering if it's possible to change the connection of a Power BI report from a Power BI Service to Analysis Service:
Thanks ! :)
FROM:
TO:
------------------------------
Ivan Erik Kragh
Consultant
EG A/S
Hi IVERK-EG,
No. It is not available to change the connection of a Power BI report from a Power BI Service to Analysis Service.
Regards,
Yuliana Gu
3 Replies
Hi IVERK-EG,
No. It is not available to change the connection of a Power BI report from a Power BI Service to Analysis Service.
Regards,
Yuliana Gu
Hi IVERK-EG & v-yulgu-msft,
Actually there is a small workaround for this, but be careful I haven't found a way to change it back to a Power BI Service connection from an analysis services connection.
1. Create a back of your .pbix file just to make sure that you can go back to your current state
2. Change the extention of the file from .pbix to .zip
3. Double click the zip file to view the content
4. Delete the file called "Connections"
5. Go back and rename the file back to .pbix
6. Open the file in Power BI Desktop and you should now be able to select "Get Data" and select the Power BI Service connection.
I've tried the workaround and it fails:
"Unable to open document
The file is corrupted or was created by an unrecognized version of Power BI Desktop. It can't be opened
sdjensen wrote:Hi IVERK-EG & v-yulgu-msft,
Actually there is a small workaround for this, but be careful I haven't found a way to change it back to a Power BI Service connection from an analysis services connection.
1. Create a back of your .pbix file just to make sure that you can go back to your current state
2. Change the extention of the file from .pbix to .zip
3. Double click the zip file to view the content
4. Delete the file called "Connections"
5. Go back and rename the file back to .pbix
6. Open the file in Power BI Desktop and you should now be able to select "Get Data" and select the Power BI Service connection.
"
