SharePoint lists - not bringing across lookup data

[cpattonusc]

I am using PowerBI and SharePoint lists that have embedded lookups in the data.  The child lookup data is coming across as blanks in the PowerBI model.  Any suggestions on having the child lookups showing in the dataset?

[christinepayton]

It's hard to tell with the amount of detail you've provided, but SharePoint list lookup columns will let you expand the ID field for the lookup list item. You could then pull in your second list that it is looking up to and relate the two tables on the ID field.