Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

Reply
Anonymous
Not applicable

Powershell to update datasource URL's

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/5...

1 REPLY 1
Jayendran
Solution Sage
Solution Sage

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.