Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have another post on the community, which has been partially answered, but not resolved.
I have a Web data source connecting to the Sage One API. Im using a POST method.
I have tested the URL, headers, content-type and content on Postman.
And they work fine.
When trying to connect via Power BI Desktop I get this error:
DataSource.Error: Web.Contents with the Content option is only supported when connecting anonymously.
Details:
DataSourceKind=Web
DataSourcePath=https://accounting.sageone.co.za/api/1.1.2/AccountBalance/Get
This is the code I'm using, I have tried with authorisation in the header and setting it separately in the poppup and data source settings:
let
body=
"{
""FromDate"": ""2017-01-01"",
""ToDate"": ""2018-01-01""
}",
url = "https://accounting.sageone.co.za/api/1.1.2/AccountBalance/Get?ApiKey={GUIDGUID}&CompanyId=123456",
Source = Json.Document(Web.Contents(url, [ Headers = [#"Content-Type"="application/json"], Content = body] ))
in Source
I have seen a few posts relating to this error but none with a solution that would work for this scenario.
Can you check this isnt a Power BI bug...
Thanks
Digiroo
Solved! Go to Solution.
Hi This has been resolved.
I am setting the Basic Authorisation in the header and setting credentials to Anonymous and it works fine.
I think the patch today has fixed 🙂
Thanks
Digiroo
Hi This has been resolved.
I am setting the Basic Authorisation in the header and setting credentials to Anonymous and it works fine.
I think the patch today has fixed 🙂
Thanks
Digiroo
could you please post your code in here?
I am having trouble with anonymous credentials, it seems my header is not correctly pushing username and password values...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
2 | |
2 | |
1 | |
1 |