Forum Discussion
Expanding SharePoint Lookups in Power Query
For some reason, I can't seem to expand all my lookup fields in Power Query, only some. I have three Lists and would like to be able to have access to all fields in each list. Custom Columns seem t...
Please see this article/video. It shows how to use the SharePoint REST API to quickly get list data, including expanding lookup columns.
Get Data From SharePoint Lists … But Fast – Hoosier BI
Pat