DataSource.Error

[jcnascime]

Hello,

I'm trying to connect to a sharepoint list, but it's returning the error below.
Could someone help me?

[v-jianpeng-msft]

Your solution is great @rajendraongole1 

Hi, @jcnascime 

You're having trouble using the SharePoint Online list v2.0 connector.
A 400 error indicates that when we use this connector to send a data request to SharePoint, it fails. The common reasons are that the SharePoint URL we are requesting is wrong, or the current file requires specific permissions, and secondly, we are not satisfied with the current limitations when using the v2.0 connector.
First of all, we can first check if our SharePoint list is in the current limit, as you can see from the image below the current limit of the v2.0 connector:

When our SharePoint list meets the requirements, we have the current issue, and we can check if there is a problem with our operation by following the connection steps of the official documentation:

As an alternative, you can use the v1.0 connector for the time being to ensure that it doesn't affect your report design and release. The above question we can find in the following connection:

Power Query SharePoint Online list connector - Power Query | Microsoft Learn

Best Regards

Jianpeng Li

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

[rajendraongole1]

Hi @jcnascime - Please check the below link to get connect the sharepoint online list from power bi.

https://youtu.be/xQMqwre9PaA?t=465

Hope it helps

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[jcnascime]

Perfect,
but the problem persists.
When I connect by clicking on implementation 2.0, an error is returned.