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...
You are aware that there is a limit of six expansions? Generally it is not recommended to do this in Power Query, Better to load all the related lists separately (like "User Information List") and then join them in the data model.