Forum Discussion

rajenderreddy's avatar
rajenderreddy
Regular Visitor
4 years ago

How to import data into Power BI Desktop using the Rest API using Basic Authentication

URL: https://apis.dev.********.com/app/v1/app

I have tried this URL using Basic Authentication in Postman app, it works fine and returns the JSON data. 

 

But when I try to connect in Power BI Desktop using Web - URL - Basic. I get an error. This URL is internal not able to access outside my organization. I have tried all authentications as Anonymours, Windows, Basic and Organizational account. None of them works.

Any help is appreciated!!

 

General Comment
Need Help

6 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    Needs more information. How do you actually authenticate against the API?  Usually you need to use anonymous here, and specify the authentication details in the request header.

    • rajenderreddy's avatar
      rajenderreddy
      Regular Visitor
      4 years ago

      Hi Ibendlin,

       

      Thanks for replying on my problem. I just use the URL in the Basic and choose the Basic Authentication and enter my GUID in username and password.

      How can I specify the authentication details in the request header? 
      Can you please post an example.
      Also I have tried same method in Microsoft Excel to get the data from API via Web option and entering the URL and basic authentication. But it didnt work for me.