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?
Solved! Go to 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.
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
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 -
What does this mean? How to set owner of data source in RDL? I am confused.
User | Count |
---|---|
5 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
8 | |
5 | |
3 | |
2 | |
2 |