Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Need help in accessing APIs in PBI Desktop

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

Need Help

2 Replies

  • Hariharan_R's avatar
    Hariharan_R
    Icon for Solution Sage rankSolution Sage
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      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