Powershell to update datasource URL's

Anonymous — Wed, 04 Sep 2019 13:15:50 GMT

Hi Everyone,

I am working on a automated deployment system that deploys PowerBI reports to a new workspace. This is all working fine but the issue i am having is updating the datasource with a new URL to get their information from. These are all SharePoint List data sources that need to be updated.

I am using the Invoke-PowerBIRestMethod to sucessfull get the data sources within a report and I can manipulate the return to change the URL but when sending the update back i just get an error.

No information is given with the error it just doesn't work.

Does anyone have a working example of updatiung a datasource with powershell?

I have seen this thread but it doesn't have a solution

https://community.powerbi.com/t5/Developer/Power-BI-REST-API-via-Powershell-Create-Datasource/td-p/511934

Re: Powershell to update datasource URL's

Jayendran — Thu, 05 Sep 2019 05:19:31 GMT

Hi @Anonymous ,

Try to find the error using Resolve-PowerBIError cmdlet or fiddler to capture the API error directly.

Just giving as the reference, to my artilce where you can find the some informations on the powershell scripts

https://community.powerbi.com/t5/Community-Blog/PowerBI-CICD-using-Azure-DevOps/ba-p/769244

topic Powershell to update datasource URL's in Developer

Powershell to update datasource URL's

Re: Powershell to update datasource URL's