Forum Discussion
'Table' and 'List' while pulling data from Sharepoint Onilne
Hi Brandimore - can you please show the Power Query formula that you are using to connect to the SharePoint site. I am hoping that you are using Implementation="2.0" rather than ApiVerison=15 or 14. If you are using one approaches, you should consider switch to the other approach to see if Power Query can import the data.
Power Query SharePoint Online list connector - Power Query | Microsoft Learn
Other consideration, what is the data type in SharePoint of the column that you are import? The "table" result in Power Query suggest some type of nested result. It might be limitation for OData API that Power Query is using (hopefully the above fixes the issue).
Hi Brandimore - can you please show the Power Query formula that you are using to connect to the SharePoint site. I am hoping that you are using Implementation="2.0" rather than ApiVerison=15 or 14. If you are using one approaches, you should consider switch to the other approach to see if Power Query can import the data.
Power Query SharePoint Online list connector - Power Query | Microsoft Learn
Other consideration, what is the data type in SharePoint of the column that you are import? The "table" result in Power Query suggest some type of nested result. It might be limitation for OData API that Power Query is using (hopefully the above fixes the issue).
I had selected 1.0 and I don't have the option to select any API version. See comment above. I get 2 options for viewer mode but I can see in PQ how you can check the API Version. This is what it shows for the 1.0 conneciton
= SharePoint.Tables("https://032gc.sharepoint.com/sites/XXXXXXX", [Implementation=null, ApiVersion=15])
This is what it shows for the 2.0 conneciton I just created
= SharePoint.Tables("https://032gc.sharepoint.com/sites/XXXXXXXX", [Implementation="2.0", ViewMode="All"])
It's in the Advanced Editor button (the one where you see all the query code) in th query editor.
