topic Re: Calling REST API with authentication in Developer

Calling REST API with authentication

Anonymous — Tue, 25 May 2021 09:22:32 GMT

Hi there!

I'm trying to fetch data from REST API directly into Power BI, and faced some issues.

I have two links for API, one is to pass the authentication (using username and password) to get the token that I should paste it into another one (API) to fetch the data.
** I couldn't share the APIs here, it's not public**

I followed this video: https://www.youtube.com/watch?v=N8qYRSqRz84 , but got stuck after hitting (OK) in the form of getting data from web.

The API connection is working good, as I tested fetching data through postman.

Any soultions for such an issue?

Thank you!

Re: Calling REST API with authentication

gooduling — Tue, 25 May 2021 13:55:13 GMT

Hi, the video you reference to is about PoverBi API, right? Did you use your 3rd side API instead? Does it really work? I'm looking for way to request data from 3rd side API onto PowerBI. Thanks

Re: Calling REST API with authentication

Anonymous — Wed, 26 May 2021 07:17:30 GMT

I tried it but it won't work, still looking for a solution

Re: Calling REST API with authentication

Anonymous — Thu, 27 May 2021 07:11:17 GMT

Hi @Anonymous ,

Did you get any error message after you clicked "OK"? If yes, could you please provide the related screenshot(mask the sensitive data) in order to make troubleshooting? In addition, please review the content in the following link and check whether that can help you connect REST API in Power BI Desktop successfully...

How to import REST API in Power BI

Best Regards

Re: Calling REST API with authentication

Anonymous — Thu, 27 May 2021 08:07:58 GMT

Thank you @Anonymous , yes sometimes I got an error as attached below:

Re: Calling REST API with authentication

Anonymous — Thu, 27 May 2021 09:41:25 GMT

Hi @Anonymous ,

The following ones are the threads which have similar problem with yours, please check whether their solution can help you resolve the problem.

"Web.contents failed to get content from site URL" displayed after trying to establish a connection in Power BI to Assemble

Known Issues and Limitations with Power BI

Working with Web Services in Power Query

Best Regards

Re: Calling REST API with authentication

Anonymous — Mon, 31 May 2021 12:40:51 GMT

Thank you @yingyinr ! Now I got a successful connection to the first API (with autorization), but got confused where should I pass the other one that will retrive the data? (based on the authorization of the 1st one)