Connecting to Sharepoint Lite List

[nford]

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.

[v-haibl-msft]

@nford

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