Expanding SharePoint Lookups in Power Query

[jrdn03]

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 to limit me to only using fields within one table at a time in PowerBI. 
Table 1: "DDR"
Table 2: "PM Updates"
Table 3: "Baselines"

In the PM Updates table - I find and expand the lookup from DDR. 

In the PM Updates table - I find and CANNOT expand the lookup from Baselines. 

In the Baselines table - I find the PM Update lookup but don't even have the option the expand and see fields to include. It has a dropdown option instead of expand. 

Not sure what to do here. Again, the reason I need this is because I need to create custom columns but based on fields across lists/tables. 

Thanks in advance. 

[ppm1]

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

[lbendlin]

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.