API with Parameters in PBI

[Anonymous]

Hey!

New to PBI but hoping someone can point me in the right direction....

I have a API that I use to pull data from an ERP databoard via Postman but it holds various params to make it work see below:

API call is a POST:  

url/api/json/reply/DataboardDataRequest

Headers used are:  

KEY	VALUE
Content-Type	application/json/data
X-HTTP-Method-Override	GET

I also have to set some criteria like the number of the ERP databoard via the body of the API as below:

{"DataboardId":10043,"Parameters":{"1":"105","5":"0","10":"2019-02-01T00:00:00.000Z","11":"2019-02-28T00:00:00.000Z","20":"0"}}

This works fine and pulls back all the info i need via postman but i would like to make this a direct link via Power BI. 

Can anyone help in how i can recreate this call via the PBI interface?

Thanks in advance.

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

Which kind of ERP do you use?

You could open "Advanced editor" in Edit queries in Power BI, write the proper code.

Here are some useful links, please check and try.

Sharing an example of pulling data from an API and getting it into Power BI

Connecting to and using the REST API in Power BI

Dynamic API parameters in Power BI

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.