POST request data sources that require basic authentication

Hi, Anonymous 

 

If the API requires basic authentication, you will need to provide the necessary credentials in your POST request. One way to do this is to include the credentials in the header of the request. Here is an example of how you can do this in Power BI:

• 1. Go to the "Edit Queries" page in Power BI Desktop.
• 2. Select the data source that requires authentication.
• 3. In the "Home" tab, click on "Advanced Editor".
• 4. In the editor, find the section of the code that sends the POST request to the API.
• 5. Add the following code before the request:

let headers = [
    Authorization = "Basic " & Binary.ToText(Text.ToBinary("username:password"), 0)
]

Replace "username" and "password" with your actual credentials. This code will create a header with the appropriate credentials.

• 6. Modify the POST request to include the headers:

let
    url = "https://api.example.com",
    body = "{""key"":""value""}",
    headers = [
        Authorization = "Basic " & Binary.ToText(Text.ToBinary("username:password"), 0)
    ],
    options = [
        Headers = headers,
        Content = Text.ToBinary(body),
        ManualStatusHandling = {400}
    ],
    result = Web.Contents(url, options)
in
    result

This code will send the POST request with the appropriate headers.

 

Once you have made these changes, save and publish the report to Power BI Service. The report should now be able to authenticate with the API using the provided credentials.

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.