Forum Discussion
Column appears in PowerQuery, but does not appear in source SharePoint Data...Kinda wierd
This is not a problem, per se, however I'm lost and I'm a not a coder so, any insight would be helpful. I have a SharePoint list that I connected in Excel and used PowerQuery to transform the data. ...
There are many, many limitations when using Sharepoint Lists as data sources. Here's one possible root cause:
Optimize Power Query when expanding table columns - Power Query | Microsoft Docs
I'll have to try that. When I was perusing all the features I came across merging the queries. I have a lot of columns expanded and a LOT of rows, so that could be part of the issue. If I try this and it disappers, then I'll know that PowerQuery having to call every single SharePoint row to retreive the data was the issue. Thank you for your insight!
