Forum Discussion
Helper IIUpdate connection string for Imported PBIX file
Dear Techies,
I have to import PBIX files to multiple workspaces. Each workspace is pointing to diffrent Analysis Services DB and we have on premises gateway too. The Problem when I try to Import PBIX files using Import API. Connection string is same across all the workspaces. Which should not be the case, PBIX file should point to respective Analysis Services DB.
Is there a way to update the connection string for all the PBIX files in workspaces?
Please post the same code
Thanks in Advance,
Latheesh
Hi latheesh89,
Action that updates all of the connections strings in each data source only works for datasets that use direct query. We can not update the connect string for import mode. More details, please review this article.
If you connect database using Direct Model, you can update the connections string by referencing to this thread. In addition, I personally suggest you'd better post the developer related cases to Power BI developer community. You will get more professional support.
Best Regards,
Angelia
3 Replies
v-huizhn-msftMicrosoft Employee
Hi latheesh89,
Action that updates all of the connections strings in each data source only works for datasets that use direct query. We can not update the connect string for import mode. More details, please review this article.
If you connect database using Direct Model, you can update the connections string by referencing to this thread. In addition, I personally suggest you'd better post the developer related cases to Power BI developer community. You will get more professional support.
Best Regards,
Angelia
latheesh89Thanks Angelia
- v-huizhn-msft
Hi latheesh89,
You're welcome, it's my honor to help you. Please mark the right and helpful reply as answer, so more people will benefit from here.
Best Regards,
Angelia