Error - Connect to Sharepoint Online List (default view) v2.0 (Beta) - does this require M365?

[TRK]

HI,  I am trying to use the new v.2.0 (Beta) connector to connect to the default view of my documents list on a sharepoint (on prem, not M365).  However,  I get an error message when I try to connect:  "DataSource.Error: Web.Contents failed to get contents from 'https:// .......Bad request".

Is there something I am missing? or a setting to resolve this?  or does this feature only work if my SharePoint is on M365? 

(I referenced the  Microsoft docs article about connecting to the SharePoint Online List -  v2.0 beta that came out in the Oct.2020 release)

[TRK]

hi Liu,

Thank you for replying.  I did read the above microsoft docs article before posting my question, but It did't help.

Our SharePoint is On Premise not online (yet) - not M365.   so it is not xxxx.sharepoint.com.....

it is https://collab.company.company webb.ca/

so if that is the issue, I assume I cannot use this beta 2.0 until we have online sharepoint?

[v-yangliu-msft]

Hi  @TRK ,
According to the error message, it seems that your url cannot be obtained. The sharepoint url obtaining format is the following style, you can check whether your url format is wrong.

This is the related document, you can view this content:

https://docs.microsoft.com/en-us/power-query/connectors/sharepointonlinelist

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.