Need help in accessing APIs in PBI Desktop

[Anonymous]

Hi,

Need help using API's for Web Data source in PBI Desktop tool.

I was able to access the API with no parament as below,

https://xyz.com/api/v2/connections.actives

But, if the API is with parameter entiry as in case below the Vendor ID, I get error as screen shot below.

https://xyz.com/api/tier/{vendorUuid}/documents
https://xyz.com/api/tier/1ac7126b-cabc-42c1-8e71-04077abfe881/documents

Please help, what is that I am missing here. I have token and have used in both the API calls.

Thanks,

Shirish

[Hariharan_R]

Hi @Anonymous 

If it has a parameter then you need to pass the value on the parameter placeholder to work with Web connector.

You can split the link into mulitple parts but need to pass the values.

Ref-https://addendanalytics.com/blog/bring-data-in-power-bi-via-apis-using-basic-authentication/

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

My Blog :: YouTube Channel :: My Linkedin

[Anonymous]

Hello Hariharan,

Thanks for your response.

I did tried the approach as per reference link, but I still get the same error. 

But, the URL and authentication token works fine in postman.

Not able to figure out.

Thanks,

Shirish