Forum Discussion
Change data source from Power BI Semantic model to on prem analysis services instance.
Hi, I have a report with a lot of work done that has a live connection to a semantic model i Power BI. Due to reasons, I have moved the semantic model to an on prem SQL Server 2022. Now I want to ...
Hi Henrik,
I encountered a similar situation. Migrated from SSAS endpoint to a XMLA endpoint (Power BI Dataset).
After a few versions we needed to switch back, but indeed the UI doesn't seem to provide such a feature.
I managed to switch back from XMLA tot SSAS by doing this:
1) Save .pbix as .pbip (a .pbip file will be saved along with two folders: .Report and .SemanticModel)
2) From the .SemanticModel folder open the 'model.bim' file and look up and edit the connection string (replace the server and database/model). Save the edited file.
3) Open de .pbip file and check whether the change was successful.
4) Save file as .pbix. Done
Maybe there are other/simpler solutions. Let me know when you find any.
Good luck!
Best regards!