Unable to use Power Query to Connect to a Sharepoint List
I'm trying to import a SharePoint list in via PowerQuery. When I try to use the root folder (and any variation there of) with my windows credentials I get an error: 400, Bad Request. I've tried using my Organizational account (like when you login the first time and use your email) it says "we are unable to connect because this creditial type isn't supported for this resource. Please choose another credential type." I'm at a loss as to what to do next... Excel, Power BI, Get & Transform, Power Query SharePoint Lists
Excel Version 1907 [Expression.Error] This native database query isn't currently supported
I have a file that contains a data connection that has been working for months. It recently stopped working after the 1907 update applied. Is anyone else experiencing an issue? How might I go about determining what part of the native query is causing the issue? I have also converted the query to a stored procedure and it doesn't work either. Is there a way to get more detailed error information?
