This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
I have built a report that pulls some data directly from a REST API. This API requires authentication, and the following code worked for me to access and pull the data directly into PowerBI:
let
Source =
Json.Document(Web.Contents("https://somesite.com/Web/",
[Headers=[
AccountLoginName="user",
AccountPassword="pass",
SourceSystemID="123",
DomainID="1"],
RelativePath="path/to/api/endpoint"However, I loaded the report today to make some modifications, and the following error was presented to me:
Expression.Error: The 'AccountLoginName' header is only supported when connecting anonymously. These headers can be used with all authentication types: Accept, Accept-Charset, Accept-Encoding, Accept-Language, Cache-Control, Content-Type, If-Modified-Since, Prefer, Referer
Can anyone give me a nudge in the right direction?
Solved! Go to Solution.
Got it sorted. Realized that the error I was seeing was not from PowerBI but from the API I was trying to connect to. Somehow my datasource stopped trying to login "Anonymous" and had got set to "Basic" A quick reset, and we are good.
This pointed me in the right direction.
https://community.powerbi.com/t5/Service/Anonymous-access/m-p/277217/highlight/true#M33295
Got it sorted. Realized that the error I was seeing was not from PowerBI but from the API I was trying to connect to. Somehow my datasource stopped trying to login "Anonymous" and had got set to "Basic" A quick reset, and we are good.
This pointed me in the right direction.
https://community.powerbi.com/t5/Service/Anonymous-access/m-p/277217/highlight/true#M33295
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 32 | |
| 26 | |
| 21 | |
| 20 | |
| 15 |
| User | Count |
|---|---|
| 65 | |
| 41 | |
| 28 | |
| 22 | |
| 22 |