Forum Discussion

cpattonusc's avatar
cpattonusc
New Member
2 years ago

SharePoint lists - not bringing across lookup data

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?

Need Help

1 Reply

  • christinepayton's avatar
    christinepayton
    Icon for Most Valuable Professional rankMost Valuable Professional
    2 years ago

    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.