Showing results for 
Search instead for 
Did you mean: 
New Member

PowerShell API Get/Update Datasource for SPN



I am trying to automate the changing of a datasource for a report with a PowerShell script


When trying to call Get-PowerBIDatasource  and Invoke-PowerBIRestMethod to update a datasource when authenticated as a service principal, I am receiving a 403 Unauthorized error. 


My SPN is an admin in the workspace and I  made sure to take over the dataset.   

I did confirm that I can do this with a non-service principal.



Frequent Visitor

I am running into the same issue. I can connect fine with the -ServicePrincipal option. Get-PowerBIWorkspace runs fine. Get-PowerBiReport runs fine as well. The script fails at the following line:

$PbiDataSourcesObject = (Get-PowerBIDatasource -DatasetId $PbiReportObject.DatasetId)


The PS error message I get is:

An error has occurred!!
Error Line Number : 110
Error Command : $PbiDataSourcesObject = (Get-PowerBIDatasource -DatasetId $PbiReportObject.DatasetId)
Error Message : Operation returned an invalid status code 'Forbidden'

Community Support
Community Support

Hi @cgstdevops 

Before you run Get-PowerBIDatasource  and Invoke-PowerBIRestMethod command, make sure you log in using Connect-PowerBIServiceAccount.


Here are similar threads you could refer to:

Powershell API Update datasource


Best Regards
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks for the reply.


I am logging in successfully with  Connect-PowerBIServiceAccount so that's not the issue. After logging in, I can publish a report, get a report and several other operations, but I am unable to modify datasources from a service account. As mentioned before, I get a 403 Unathorized error. It looks as if service principals are not allowed to call these methods.  


I was able to do this with an actual user, so I am currently impersonating a real user to accomplish this automation. 


Thanks again and please let me know if there is something I am missing.



Hi @cgstdevops ,


Can you provide your full powershell script, so that I can try to reproduce the issue ? 


Helpful resources

May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through June10th!

Power BI Dev Camp Session 22 without aka link and time 768x460.jpg

Check it Out!

Watch Session 22 Ted's Dev Camp along with past sessions!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!

Top Solution Authors