Update connection string via API

[Anonymous]

Hello,

I have a script written in Powershell to publish all the reports to powerbi service without opening it using Rest api and it is working fine.

I want to update this script which will ask user input to select the Redshift environment and point the data source selected by user.

So, the pbix report data source connection string will be updated without opening the pbix file.

I need to achieve this using Powershell script.

Please help me out achieving this scenario.

Thank you in advance.

[v-xulin-mstf]

Hi @Anonymous,

Is your issue solved?

If the issue has been solved, please adopt your solution to help others.

Thanks! 😉

Best Regards,
Link

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[v-xulin-mstf · Accepted solution]

Hi @Anonymous,

Please refer this about how to update the data source connection string using powershell:

https://stackoverflow.com/questions/55900512/how-to-update-the-data-source-connection-string-using-powershell-in-the-xml-file

https://docs.microsoft.com/en-us/power-bi/report-server/connect-data-source-apis

Best Regards,
Link

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks @v-xulin-mstf this resolved my issue.