Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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?
Solved! Go to Solution.
Use the expand arrows for the column to expand the Record to the Author's actual name.
Use the expand arrows for the column to expand the Record to the Author's actual name.
@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.
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
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 10 | |
| 6 | |
| 5 | |
| 4 | |
| 2 |