Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

API with userinputs

Hi Guys,


I have a problem, which I hope you guys can help me with.


There is a report I am trying to recreate in Power BI. In the report there is a box with user input options. The options selected by the user should be added in to API call and get data back for exactly what is selected by the user. There are 5-6 different user inputs and for most of them there are different API endpoints. 


When the call is done, then there is another endpoint to check if the status of the asked data is ready or not. When it is ready, it should be collected and downloaded in to Power BI and show up in the visualisations. 


Is this something which is even possible with Power BI? We do also have the possibility to send the result data to Azure Data Warehouse, but will we be able to auto-refresh the report when new data is available in Azure Data Warehouse?


Are there any other solutions like power apps/microsoft flow?


Thanks in advance.

Super User III
Super User III

There are parameters in Power BI that let users enter or select values. These values can be referenced in your queries that retrieve the data.


You can add conditions to your queries so that an api is then called or not. 


With a pro license you can run your queries 8 times a day and check if there is new data (If the logic doesn't imply to check against the existing data in Power Query. Power Query doesn't store data like a database, so there is no concept to compare new data against existing data in Power BI. The logic if there is new data available must come from the source itself)


A workaround for the above problem might be achievable using Flow (read and write out the details of the latest refresh and compare it against the current data from the source). But that depends on your actual data and needs.



Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

Helpful resources

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors