Direct Connection to SharePoint Table, not navigate

[steveapa]

Hi All.
It seems like when you connect to a sharepoint list in Excel or Power BI, all lists are downloaded and then you navigate to the list you want. I would like to connect directly to one list... My excel vba ado connection that work great and is fast:
cn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=0;RetrieveIds=Yes;DATABASE=https://teams.XXXXXXX/sites/XXXXXX/;LIST={xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx}"

I found that there is an M Function: OleDb.Query command, but how do I use the connect string above with this command??

Something like I use to connect to Denodo: The driver name is the ODBC connection name as a variable based on 32 or 64 bit connection
let
Source = Odbc.Query("dsn=" & #"Denodo ODBC Driver" , "

select
tep_project_snapshots.project_number,
tep_projects.project_name,
tep_project
...
Or Like I connect to Oracle
let
Source = Odbc.Query("dsn=" & #"TED Connection (ADW)","
select
REV.DISPLAY_PROGRAM_NUMBER ""RTS#.REV"",
REV.PROGRAM_NM,
REV.PROGRAM_DESC,
REV.PROGRAM_STATUS_DESC,
REV.CUST_NAME,

Thanks
Steve
Harrisburg, PA