Forum Discussion
Update Existing GatewayId/DatasourceId to Paginated Report using REST API
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:
- remove the duplicate data source which my report doesn't use - https://docs.microsoft.com/en-us/rest/api/power-bi/gateways/delete-datasource
- 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.
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
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