Update connection string for Imported PBIX file

[latheesh89]

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

[v-huizhn-msft · Accepted solution]

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

[latheesh89]

Thanks 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