How to extract a power bi value and insert that value in a sql database with Power Automate?
I'm working with the power automate preview visual because I want to create a flow that extracts the power bi value from a card visual and insert it as a row in a table located SQL Server.
I have done the same before calling to an API, extract the value from that API and insert it in SQL Server like this (ir works perfectly):
I have used the same process for getting the power bi value but it doesn't work. Here is the flow I have used:
1) First, I use a GET process with HTTP action. On the URL parameter I use the "pais seleccionado" item which is the metric of the visual card I want to get (it shows the country selected in a slicer).
2) After, I parse that item to JSON object so I can insert it without format problems in a SQL Database:
But I need a schema example for that item and I can't find it.
3) Finally, I use an "insert row in sql" action:
I've been looking for a solution and try everything I have foundb but it doesn't work.
It would be fantastic if anybody can help me with this...