Forum Discussion
Solved
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 cop...
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
