Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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.
Solved! Go to 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:
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.
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:
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.
It is not working for me. Can you provide me with more details or a code snippet?
Regards
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)
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.