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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Daemetius
Helper II
Helper II

How to display name of Created By from Sharepoint Online?

Hello,

 

So I'm trying to bring author information from a list that is in Sharepoint Online. However when I check, all I see are UserIds and the Author field has Record link which takes me to a small table containing info on that particular user who submitted an item in the list.

 

Isn't there a way to just get the author as a text value from that field and display it in the graphs? 

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

Use the expand arrows for the column to expand the Record to the Author's actual name.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

3 REPLIES 3
Greg_Deckler
Super User
Super User

Use the expand arrows for the column to expand the Record to the Author's actual name.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...


@Greg_Decklerwrote:

Use the expand arrows for the column to expand the Record to the Author's actual name.


 

What expand arrow? Is this in Query Editor? This is what I have. 

 

author column.png

 

 

All I can is drill down and it gives additional information, but I want to extract the drilled down data. Title gives name of the author here, so I would like to extract that information 

 

drill down.png

Those little arrows in the column header on the right side.

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors