Forum Discussion

tbuck8384's avatar
tbuck8384
New Member
2 years ago

How do I connect to Web API data with Power BI Desktop?

I am trying to connect Power BI Desktop to a website API and was given the following information on the backend of our web portal to configure API and authentication. See screenshot below. How do I e...
Need Help
BIBB's avatar
BIBB
Advocate I
1 year ago

What other options apart from "ClientCredentials" do you have? If you only have an legged oauth authentication, you will need to build a custom connector, which is more complex. 

If you have a "basic" option, you should be able to build the query in the Power Query editor and the function that you require Web.Contents. We have written a very complete article, including sample code, about it. 

https://www.bibb.pro/post/web-contents-and-apis-in-powerbi

Web.Contents in Power BI





  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

    That article does not cover token authentication.

    • BIBB's avatar
      BIBB
      Advocate I
      1 year ago

      I believe your comment is a bit misleading as the article contains several code samples implementing token authentication. 

      • lbendlin's avatar
        lbendlin
        Super User
        1 year ago

        Hmm, can't seem to find that word in the article.