Forum Discussion
Dataflows: Basic Auth with blank password
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!
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.comMore information:
https://www.linkedin.com/pulse/dataflows-power-bi-sonarqube-sonarcloud-api-basic-auth-michalczyk
5 Replies
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.comMore information:
https://www.linkedin.com/pulse/dataflows-power-bi-sonarqube-sonarcloud-api-basic-auth-michalczykHave you tried to provide the password as an empty string instead?
