Forum Discussion
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.
I was able to solve my issue following the steps for list structured column.
4 Replies
- v-zhangtiCommunity Support
Hi, jaytrice26
Please refer to the following links in the hopes of helping you.
Solved: Expanded data and list Problem - Microsoft Fabric Community
Solved: Record data from sharepoint List - Microsoft Fabric Community
Solved: SharePoint Online List not displaying data - Says ... - Microsoft Fabric Community
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- jaytrice26Helper I
Thank you for the reply. While these are very closely similar to my issue they are not exact matches. I don't have any records that contain hidden data. Just lists but I cannot expand the lists in the columns. Any other suggestions?
- jaytrice26Helper I
Thank you for the reply. While these are very closely similar to my issue they are not exact matches. I don't have any records that contain hidden data. Just lists but I cannot expand the lists in the columns. Any other suggestions?
- jaytrice26Helper I
I was able to solve my issue following the steps for list structured column.