Forum Discussion
Dataflows: Basic Auth with blank password
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
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
