Forum Discussion
How to send data to an external API in Power BI?
I have embedded Power BI in my React application, and I need to export the data inside a table to a REST API in my backend.
To explain further, I have a bar chart, and I have added a drill-through action. It will open up a table that has been filtered depending on which bar I have clicked on. I want to add a button that will send the data inside this table to an API in my backend.
1. How do I do this in Power BI?
2. I am currently using Premium per user license. Can I do it in my current plan, or do I need to upgrade to some other pricing plan?
I think you will need to use Power Automate to create a flow to get the API into your backend table. You can trigger the flow using a button directly in Power BI.
Documentation on setting up a Power Automate button:
https://learn.microsoft.com/en-us/power-automate/trigger-flow-powerbi-report
The actual Power Automate flow will vary a bit based on your exact requirements but below are a few general articles to get you started:
https://www.linkedin.com/pulse/power-automate-2-ways-call-api-sara-freitas
https://www.process.st/how-to/call-api-in-power-automate/
Please mark as a solution if this answers your question!
1 Reply
I think you will need to use Power Automate to create a flow to get the API into your backend table. You can trigger the flow using a button directly in Power BI.
Documentation on setting up a Power Automate button:
https://learn.microsoft.com/en-us/power-automate/trigger-flow-powerbi-report
The actual Power Automate flow will vary a bit based on your exact requirements but below are a few general articles to get you started:
https://www.linkedin.com/pulse/power-automate-2-ways-call-api-sara-freitas
https://www.process.st/how-to/call-api-in-power-automate/
Please mark as a solution if this answers your question!