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 Team,
I am tring to access sharepoint page data from Power Bi and getting the follwoing error when I try to connect.
The WWW-Authenticate header doesn't contain a valid authorization URI. Header value: 'Bearer realm="03b07a97-a58c-4be0-8ad3-d308163f8fa9",client_id="00000003-0000-0ff1-ce00-000000000000",trusted_issuers="00000005-0000-0000-c000-000000000000@*,00000003-0000-0ff1-ce00-000000000000@03b07a97-a58c-4be0-8ad3-d308163f8fa9",NTLM'.
Can someone help me please? Its quite urgent.
Thanks
Solved! Go to Solution.
I resolved this issue using windows credentials instead of Organisational account credentials.
Thanks
Did you see this thread? It is old, but same issue.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThanks for the response. Can someone please advise me , How can I access the Sharepoint List as data source from Power BI.
Thanks
Hi @Anonymous ,
well, like everything else from main menu "Get New Data":
This generates for me the code like below:
let
Source = SharePoint.Tables("https://mycompany.sharepoint.com/sites/myteam/", [ApiVersion = 15]),
#"Table" = Source{[Id="1cd9225b..."]}[Items],
#"Renamed Columns" = Table.RenameColumns(#"Table",{{"ID", "ID.1"}})
in
#"Renamed Columns"
A couple of suggestions:
Kind regards,
JB
Thanks. It fails before the import wizard. I feel like some access issue, I have requested to check my access to the Sharepoint site. I will update how I go.
Thanks
I resolved this issue using windows credentials instead of Organisational account credentials.
Thanks
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 |
---|---|
102 | |
48 | |
19 | |
13 | |
11 |