I am trying to connect to a Sharepoint Online List and getting the following error. What is the cause of this issue? Does it have to do with the Sharepoint List configuration? Does the fact that I am trying to connect to Sharepoint Lite matter? Any help here would be greatly appreciated as this is a chance for PBI to gain traction at a fortune 500 hospitality company.
1 Comment
v-haibl-msftMicrosoft Employee
It seems to be related to your sharepoint. To make this work with Power BI, the endpoint needs to return an URL which looks like
WWW-Authenticate: Bearer authorization_uri="https://login.windows.net/a1a2578a-8fd3-4595-bb18-7d17df8944b0/oauth2/authorize"
Where the GUID is the AAD tenant ID. This cannot be done entirely via configuration, it involves writing code on the service side.
You can also take a look at the solution of this thread.
Best Regards,
Herbert