Failed to load SharePoint list V2.0

[mabdelrahman76]

Hello everyone, i am ecncoutred to load data model in BI desktop when i connect to SharePoint list V2.0.

sucess connect with SharePoint list V1.0

any idea how to resolve this issue.

thanks

[v-xiandat-msft]

Hi @mabdelrahman76 ,

Please open power query and navigate to the queries that are showing the error. Check each step within the query to find where the error is, and share the shareshot.

Best Regards,

Xianda Tang

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

[amitchandak]

@mabdelrahman76 , Are you not able connect after following this process

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-sharepoint-online-list

Also, Clear permission once for the connection in Home Tab -> Transform Data -> Data Source Setting and try

[mabdelrahman76]

@amitchandak  thanks for the feedback, i already tried the mentioned step, i cleared the cash.

i tried from different PC and still the issue persit.

i am able to load other list from same SharePoint site.

the list i am trying to load has columns which has vlokup from different list in same SharePoint site.

i am able to load the Data for the effated list but with V1.0 connection fo Sharepoint.

Thanks

Mohamed