Update Existing GatewayId/DatasourceId to Paginated Report using REST API

[mananchaya]

I'm working on updating the data source to the paginated report using REST API.

I know the way to manually set it on the https://app.powerbi.com/, but I need the way to set it by the REST API call.

Currently, I'm using the 'UpdateDatasourcesInGroup' to update the connection details to the paginated report.

But when I called 'GetDatasourcesInGroup' of my paginated report, it returns the null value on 'DatasourceId' and 'GatewayId' of my data source name (which I have created on the Power BI Report Builder).

Does the power BI REST API have the method to call to rebind/update/set the shared/existing data source to the specific report?

Note: need the way to rebind/update/set like an image down below in form of the calling REST API.

Thank you.

[mananchaya · Accepted solution]

I've got the solution by calling the method to update the data source api twice.

Previously, I called this method: https://docs.microsoft.com/en-us/rest/api/power-bi/reports/update-datasources-in-group

But due to my report was connected to multiple gateways with the same connection string and credentials.

So, I have to:

1. remove the duplicate data source which my report doesn't use - https://docs.microsoft.com/en-us/rest/api/power-bi/gateways/delete-datasource
2. call the update data sources in group twice - https://docs.microsoft.com/en-us/rest/api/power-bi/reports/update-datasources-in-group
   • first one: calling to update the database to 'tempDB' or the database name that is not the same as the correct one.
   • 2nd: calling to update to the correct one.

At first, I've only called to update to the correct one, but I think the report has already binded to that connection details, so the power bi won't re-map the data source/gateway to us.

[Anonymous]

It is not working for me. Can you provide me with more details or a code snippet?

Regards

[v-luwang-msft]

Hi @mananchaya ,

 To the best of my knowledge, you need to update the RDL file before publishing for right now. That's the only way around it as far as I know right now.

Refer:

Embed paginated reports in your own application for your customers (Preview)

Reports - Update Datasources

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[mananchaya]

Thank you @v-luwang-msft for your reply.

I've already tested to call this one:  Reports - Update Datasources, but it still doesn't work.

I'm trying to update the RDL file before publishing and investigating more on your reference document.

Best Regards,

Mananchaya