Use PowerBI to perform API post command?

[ksteever]

Hello!

I have a dashboard built out in PowerBI with a list of items from a data source.  Currently we take information from this dashboard and use it to manually create issues for teams to work on. Ideally I'd like to be able to click a sort of check box at the end of the table (or similar; see below) that when clicked, grabs the information from the line that indicator exists on and then performs the API action with the additional information from that item.

Is it possible to do either of these things via PowerBI?

If so, is it possible to collect and parse the response body to store a parsed value from that response in a table?

[ksteever]

Hi @Anonymous ,

The Power Automate for Power BI visualization can help with this I believe, but from what I've seen in my searches it's going to perform the action(s) for everything on screen it appears. I'd like to run it in a targeted fashion hence looking for a checkbox per line or similar.  This table is quite long and I do not want to barrage the ticketing system as not everything in the list would be subject to the API. 

Here's a couple YT links that show the PowerAutomate functionality, but everything I find is doing everything against an entire table instead of specific/selected items.

https://www.youtube.com/watch?v=9_JaY92VCSQ

[Anonymous]

Hi @ksteever ,

As far as I understand it, there doesn't seem to be such a feature at the moment because powerbi is a visualization tool and the interaction only applies to data filtering and does not allow for data transfer.

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.