Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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:
They also, further down provided this info:
I have tried the URL with no luck. If someone could point me in the right direction, I would be most appreciative.
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.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.