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 ...
That's odd that it's not working for you.
I routinely use this method to change from PBI semantic model -> PBIX opened on local machine (using Analysis Services connection).
Regardless, you can do the same thing manually by opening a copy of the report PBIX as a ZIP file and deleting these two files:
- SecurityBindings
- Connections
(This is essentially what the Hot Swap Connections tool does in the Disconnect-PBIX function.)
Then you should be free to open the report and connect to an Analysis Services source.
Does this method work for you?
Thanks a lot!
It worked for me!