Forum Discussion
Change live connection data source Analysis Services, dev to production
Hello, I have a pbix connected to an Analysis Service tabular model, I need to migrate it to the customer's environment, the data sources are on another machine, and on another network.
When I try to configure the new data source in pbix, I get a connection error that does not allow me to proceed with this change.
My idea was to change this server and bank in pbix, with the data from the production server and then publish the pbix in the client's pbi workspace.
But I can't change the data source, because the error occurs due to not being able to communicate with the bank in the production environment.
4 Replies
Anonymous
I have had good luck with the process in this article.
https://powerbi.tips/2020/05/hot-swap-power-bi-report-connections/
Basically you strip out all connections then open the report and go through Get Data again and it hooks into the new source.
It's an interesting alternative, no doubt, but I haven't been able to test it yet.
Anyway, I'm grateful for the help.
In fact, I had already tried to use it on another occasion using external tools.Hot Swap Report Connections - External Tools - (powerbi.tips)
