API connections with userinputs

[bininja]

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.

[v-piga-msft]

Hi @bininja ,

---

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. 

---

From my knowledge, I'm afraid that we may not achieve your requirement in power bi desktop currently.

You may try another way such as query parameter.

Please refer to this similar thread which may help you.

https://community.powerbi.com/t5/Power-Query/Rest-API-With-User-Selected-Parameters-As-Data-Source/t...

Best Regards,

Cherry