Taking over the Paginated report removes the gateway settings

[Anonymous]

Hi, 

We are working on a script to update data source connections of multiple reports.  When we use the below API to take over the report and update data sources, the gateway settings are reset. Is there any way to add gateway to the paginated report data source from PowerBI rest api.

Reports - Take Over In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn

[Anonymous]

hi @v-yueyunzh-msft

I tried using the update data source api, but its not allowing me to update the data source without taking over the report.  It mentions a limitation that only the data source owner cant update the data source.

[v-yueyunzh-msft · Accepted solution]

Hi， @Anonymous 

In my understand about the "The user must be the data source owner." , you can try to ask the data source owner give you also the "Owner" role for this data source to check if it can be modified.

For this , you can also refer to :
Add or remove a gateway data source - Power BI | Microsoft Learn

Additional gateway security roles for Power BI | Microsoft Power BI Blog | Microsoft Power BI

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[v-yueyunzh-msft]

Hi , @Anonymous 

Based on my test and research, whenever we took over one dataset from one user to another user, the dataset setting won't be saved for the previous user and we need to configure them again for the security reason, so if there's a chance to skip the take over dataset process but directly using the update data sources/ update gateway kind of these rest APIs and checking if they can meet your automatic requirement?

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

Gateways - Update Datasource - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly