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

[rajenderreddy]

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!!

[lbendlin]

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]

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.

[lbendlin]

You need to BASE64 encode your username and password.

Basic Authentication (Encode Credentials to Base 64) | API Connector (mixedanalytics.com)

[rajenderreddy]

Hi,

I have tried as you mentioned but still I get the error. Please see the attachments for error and how I am trying to connect.

[lbendlin]

you didn't specify anonymous auth.

[rajenderreddy]

I have tried as you mentioned, But didn't work for me still. Shows as "Couldn't authenticate with credentials provided".