Forum Discussion

jaytrice26's avatar
jaytrice26
Helper I
3 years ago
Solved

Column data is referencing data from another SP list

I have connected my SP list to my power bi and some of the data in the column says "list" instead of the actual name. For example: in the "Part" column is should list the hardware type like: docking station, professional laptop, usb headset and in "Location" it should show the names of the sites I manage(Austin, Denver, Omaha). That is how the data appears in my SP list. I reviewed the settings in my SP and see that some of the data throughout my site is referencing information from different lists within the site. I did connect the tables in the Model to connect where they are referencing data in other lists but when I plug in the fields into my report its not bringing back any information other than "list" or "blank.

 

4 Replies