Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
merrsparsons
New Member

Connect GraphQL API with Oauth2

I am trying to pull data from a website that my company uses for digital work instructions. We pay them for the API access and they have provided documentation for their API, but they are not familiar with Power Bi. I have tried every way I know how (which is limited) to connect the API to Power Bi and I get nothing but errors.

 

Previously when I tried this, they provided me two different revocation tokens (no idea what this is). But the current documentation mentions nothing about using revocation tokens.

 

In the most recent documentation, they provided this:

 

merrsparsons_0-1714707177989.png

 

They also, further down provided this info:

 

merrsparsons_1-1714707241550.png

I have tried the URL with no luck. If someone could point me in the right direction, I would be most appreciative.

2 REPLIES 2
v-yohua-msft
Community Support
Community Support

Hi, @merrsparsons 

Make sure that OAuth2 is set up correctly as an authentication method in Power BI. This typically involves specifying the authorization URL, token URL, client ID, and client secret provided by the API provider. You can check the following link:

Connect to Snowflake with Power BI - Power BI | Microsoft Learn

If you're not already using Power BI's web connector, try using Power BI's web connector to connect to the API. You'll need to enter the API URL and set the authentication method to OAuth2. 

 

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you for replying.

 

I received two revoke tokens and a client ID.

 

Maybe its the desktop version I am required to use at work, but the web connector does not give me the option to select OAuth2.

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors