Forum Discussion

samiHaque's avatar
samiHaque
New Member
2 years ago
Solved

created by column showing as 'list'

Hi. I am new to power Bi and wanted to created a dashboard from data on a sharepoint list that is recorded by a canvas powerapp. I have managed to extract the data from the SP site into Power Bi and ...
  • AmiraBedh's avatar
    2 years ago

    Try to locate the 'Created By' column, which is currently showing as 'list'. Click on the column header dropdown and select 'Expand to New Rows' or 'Expand Record Column' depending on your version of Power BI. You might see options to select specific fields within the 'Created By' column such as Email, DisplayName, Claims...

     

    After expanding, select the relevant fields that you need to display. Typically, you would select DisplayName or Email to show the name or email of the user who created the record.

     

    Rename and clean up.