Hi @sdeoghar. It looks like it's common enough that other people have run into this, but I don't know what options you have available to you to fix it. This blog mentions one way that worked, but it involves running an update for SP. There's also this community post that has a few ideas, including logging in as an Organizational Account.
From what I can tell, it's not a problem with your data in SharePoint list. Most of the examples I've seen were for SharePoint on-prem. I see you're connecting online. Let us know if nothing above helps.
I'd still suggest trying them out. The list from Excel is through Power Query, which is Get Data in Power BI. They're not 100% the exact same, but it's pretty close.
The post that didn't have a resolved answer still had a workaround of logging in as an organizational account.
It might not be possible to find someone with the exact same scenario, but you might find several things that are close and have the same solution by typing in the exact error message into Google. Options for Power BI or Power Query will be relevant.
Based on my understanding, you are trying to connect to SharePoint online list via OData feed data source type in the Power BI Desktop but get errors, right?
Based on my test, when we connect to SharePoint online list use OData feed, we need to append _vti_bin/listdata.svc at the end of site URL. For example, the URL of the SharePoint online list is this: https://microsoft.sharepoint.com/teams/Qiuyun01/Lists/list01, then we need to specify the OData URL like this:
In your scenario, please check if the URL is correct. And type the URL without copy and paste. In addition, in Power BI Desktop, there is a OOTB data source type for us to retrieve SharePoint online list, it's SharePoint Online List data source. See:
If you have any question, please feel free to ask.
Best Regards, Qiuyun Yu
Community Support Team _ Qiuyun Yu If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.