Forum Discussion

Aman_90's avatar
Aman_90
Regular Visitor
1 year ago

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.

 

 



"Power BI Report Server "
Power BI Report Server integrated to SharePoint

4 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

    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's avatar
      Aman_90
      Regular Visitor
      1 year ago

      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.



      • lbendlin's avatar
        lbendlin
        Super User
        1 year ago

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

         

        What is SS ?