Forum Discussion
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...
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.
This is the List.
After Loading is Power Bi:
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.