cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DavidPi
Helper I
Helper I

API - Update Datasources In Group for Paginated Reports - Unauthorized

Hello,

 

I try to update RDL report data source via API (using service principal).

 

{
"updateDetails": [
{
"datasourceName": "JIRADB",
"connectionDetails": {
"server": "SQLBIP1DP1",
"database": "COGNOS_REPORTING"
}
}
]
}

 

And I receive this return message:

 

{
"error": {
"code": "Unauthorized",
"message": "Update datasource JIRADB is unauthorized"
}
}

 

I can not find solution. Service principal is admin in workspace. 

But I can not set service principal as owner on data gateway data source (error msg no email address) - is this the problem?

1 ACCEPTED SOLUTION

I found the solution - You first need to call take over API - Reports - Take Over In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn. Then You can call API to change data source. 

View solution in original post

3 REPLIES 3
v-shex-msft
Community Support
Community Support

Hi @DavidPi,

AFAIK, update dataset should work for power bi reports. If you are work with RDL files, please try to use the update data source API if helps:

Reports - Update Datasources In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

I found the solution - You first need to call take over API - Reports - Take Over In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn. Then You can call API to change data source. 

Yes, I use this API, but receive message - Update datasource JIRADB is unauthorized.

I do not know which permision I should have more. In Doc I see - 

  • The user must be the data source owner

What does this mean? How to set owner of data source in RDL? I am confused.

Helpful resources

Announcements
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.