cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ksivaganesh99 Frequent Visitor
Frequent Visitor

Dynamic data refresh( REST API call) based on slicer drop-down selected value

We want to develop reports which connects to different REST endpoints. In that report we need a dropdown slicer (column value) and when that slicer dropdown value is selected it should call another API with that selected value as query parameter.

 

Is there a way to achieve this in Power BI? Something like Live query using REST APIs.

3 REPLIES 3
Super User
Super User

Re: Dynamic data refresh( REST API call) based on slicer drop-down selected value

Hi there I would suggest if you want to achieve something like this, you would have to look at using Power Apps and even potentially Microsoft Flow (which can be called from a Power App). This could then be integrated into a Power BI report using the Power Apps Custom Visual.
Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
ksivaganesh99 Frequent Visitor
Frequent Visitor

Re: Dynamic data refresh( REST API call) based on slicer drop-down selected value

That is really cool but can I develop reports( Area chart, Stacked chart) in Power Apps similar to Power BI? 

 

I mean when I change the dropdown value it should call an API and change the Area chart values. How can I acheive this?

Super User
Super User

Re: Dynamic data refresh( REST API call) based on slicer drop-down selected value

Hi @ksivaganesh99

 

Currently as far as I am aware that is not possible in Power BI

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"