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?
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.