Calling REST API with authentication

[Shaden]

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!

[v-yiruan-msft]

Hi @Shaden ,

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

[Shaden]

Thank you @v-yiruan-msft , yes sometimes I got an error as attached below: 

[v-yiruan-msft]

Hi @Shaden ,

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 ...

Known Issues and Limitations with Power BI

Working with Web Services in Power Query

Best Regards

[Shaden]

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)

[Shaden]

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

[gooduling]

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