cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cgstdevops
New Member

PowerShell API Get/Update Datasource for SPN

Hello,

 

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.

 

Thanks!

4 REPLIES 4
migs
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'

v-juanli-msft
Community Support
Community Support

Hi @cgstdevops 

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

https://docs.microsoft.com/en-us/powershell/module/MicrosoftPowerBIMgmt.Profile/Invoke-PowerBIRestMe...

 

Here are similar threads you could refer to:

Powershell API Update datasource

https://docs.microsoft.com/en-us/rest/api/power-bi/gateways/updatedatasource#windows_credentials_exa...

https://docs.microsoft.com/en-us/power-bi/developer/encrypt-credentials

 

Best Regards
Maggie
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.

 

Neal

Hi @cgstdevops ,

 

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

 

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

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 May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!

Top Solution Authors