Dataflows: Basic Auth with blank password

[tuken]

I have a dataset that works fine in Power BI Desktop but not in Dataflows. It has a source that connects to a rest api . API key is used as the username and the password is left blank.

When I copy the dataset to dataflows this error message appears:

"The given credential contains a property with a null value. Data source kind: Web. Property name: Password."

How can I fix it?

Thanks!

[pmichalc · Accepted solution]

I found a solution to use Basic authentication without password!

You need to select anonymous authentication, and in the code paste this:
Source = Json.Document(Web.Contents(https://<yourpath.com>, [Headers=
[
#"Content-type"="application/json",
#"Authorization"="Basic <encoded username:>"
]]
)),

Use https://www.base64encode.org/ to decode, remember the colon at the end of the username is very important!

In PowerBI.com you have to set anonymous authentication with skip test connection.

Scheduled refresh works for me this way!
Of course, I also use the Personal Gateway on PowerBi.com

More information: 
https://www.linkedin.com/pulse/dataflows-power-bi-sonarqube-sonarcloud-api-basic-auth-michalczyk

[msangster]

FYI you can also do binary encoding within powerbi:

Binary.ToText(Text.ToBinary("your username:"), 0)

Update: Updated to reflect Ibendlin's comment about the colon. 

[lbendlin]

Don't forget the colon.

[lbendlin]

Have you tried to provide the password as an empty string instead?

[tuken]

Hi @lbendlin , thanks for your answer.

I've tried with "" in the password but it didn't work either.