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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
vincetaylor
Helper I
Helper I

Get Data imports names [List] and [Table]

Hi all

I am importing data from a SharePoint online list into PowerBi desktop. Most of the columns imported properly. Some fields did not import properly

 

1. The [Created By] field is an autogenerated SharePoint field of type "Person or List". 

  I expected to see the name of the Creators. However all I see is the word [List] instead of the Creator name. See screenshot below

 

2. The [System] field is a Lookup. I expected to see a list of Systems, instead I see [Table]

3. The [Assigned] field is of type "person or group". I expected to see names. Instead it is imported with the text [Table]

 

Assigned.JPGtable.JPGcreated by.JPG

 

Why is the data not being imported properly?

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@vincetaylor , Open Power query, and check, you should get an expand option for these columns, once you use that you will get columns

View solution in original post

2 REPLIES 2
v-yueyunzh-msft
Community Support
Community Support

Hi , @vincetaylor 

Based on your screenshot, you can see that the current field returns data of the [Table] and [List] types.

The reason for this behavior is because you imported the Power Bi Desktop without properly processing the data in Power Query Editor.

 So you need to click "Transform data" in Power BI Desktop to enter the Power Bi Query Editor .

vyueyunzhmsft_0-1669169028961.png

In Power Query, you can delete fields you don't want, then extend your Table or List fields to achieve the data results you want before "Apply" to Power BI Desktop.

 

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

amitchandak
Super User
Super User

@vincetaylor , Open Power query, and check, you should get an expand option for these columns, once you use that you will get columns

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.