JSON API with Specific Parameters

[Anonymous]

Hi, 

I am new to power BI - I have basic knowledge with BI platforms and APIs.

Goal:

Retrive data and showcase it to the end user - the user needs to selected the parameters (client name, and date). 

How: 

The data is being pulled by an API - with the parameters specified byt the user, then specific data will be provided. 

I was able to connect a JSON API and uploaded into power BI - the issue is that that API was already preselected and only provides data to a single client I want to have multiple clients and trigger diffrent APIs. 

Is this possible to acconmplish? Basically I want to have a dropdown with the clients use the name of the client and trigget the API. 

Thanks! 

[ImkeF · Accepted solution]

If my understanding is correct, this should be doable with 2 parameters that hold all clients names and possible dates (or a free-form field for the date)  and a function that calls the API(s) and takes the selected parameter as an input.

So the users can select their bits through the API and then refresh the dataset. (No scheduled refresh through the PBI service then, though. )

See this article for example on how to write a function: https://www.poweredsolutions.co/2019/02/19/parameters-and-functions-in-power-bi-power-query-custom-f...

[Anonymous]

I will try to do this, it sounds like a viable solution! Thanks for your help!

[v-piga-msft]

Hi @Anonymous ,

From my knowledge, I'm afraid that this is based on your JSON API, you'd better have a contact the developer of the API and check if he could modify it.

Otherwise, I'm afraid that you need to trigger diffrent APIs to get the data of multiple clients.

Maybe @ImkeF  will have other ideas.

Best Regards,

Cherry

[Anonymous]

Thanks for your feedback !