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 Des...
General Comment
Need Help
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.