Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Aman_90
New Member

Issue Connecting SharePoint List Column to Power BI.

Hello Everyone,

I have connected my SharePoint List with Power BI, but the ID column values are reflecting as [List]. I tried using the Expand and Extract options but only get some numbers instead of the ID.

Note: The expanding option still shows some numbers instead of names and IDs. When exporting data in CSV, names are displayed, but in SharePoint, it's showing "List."

Please help if there is a solution.

 

Thanks,
Aman Shaikh.

 

 



3 REPLIES 3
lbendlin
Super User
Super User

Instead of expanding these lookup columns completely, consider adding the "User Information List" list  to your data sources and then join it into your data model.

Aman_90_0-1729863874906.png

This is the List.
After Loading is Power Bi:

Aman_90_1-1729864023944.pngAman_90_2-1729864061495.png



Hey,
Thanks for your response but I am new user so I have not understood. Can pls explain again and if you attach some SS that will be great for me.



 consider adding the "User Information List" list  to your data sources and then join it into your data model.

 

What is SS ?

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.