Ho to Change Author ID from SharePoint list to names in Power BI?

SharePoint Asked by Bhuvana Sundar on December 8, 2021

I am creating a dashboard with share Point online list. I want to show number of task created by each person. But, the report is showing numbers (Author ID) How do I change to names?

One Answer

Here is the detail level steps.

Step-1: Connect to the SharePoint List.

Step-2: Click on "Edit Queries"

Step-3: Click "Choose Columns"

Step-4: Choose your columns and "Author"

enter image description here

Step-5: Click on symbol given as shown in the image

enter image description here

Step-6: Choose the column "Title"

enter image description here

And now you will have your name.

enter image description here

Let me know if you need any additional details.

Answered by Aakash Maurya on December 8, 2021

Add your own answers!

Ask a Question

Get help from others!

© 2024 All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP