1

I am trying to generate a report on a Sharepoint List with Power Bi. The list is a custom made list solely used for users to raise tickets

With Power Bi, I am able to pull the Sharepoint List Data however the data that i got is not very user friendly. Instead on a user's display name I get IDs. Is that normal? i have attached the Fields that Power Bi got from my helpdesk list

Some of these Field items are foreign to me as well

enter image description here

1

Go to "Edit Queries" on the home tab. This is the data scrubbing and transforming layer.

enter image description here

For the "junk" columns: These are metadata fields in the list, that could be useful at some point. For now they are a nuisance, so, Delete the columns you do not recognize or use. (You can always retrieve a column you deleted by editing the query steps on the right).

As for the missing Display Names: Get those by "expanding" the UserID column. It will be named something reminiscent of the column name for the Person/Group field in your list. There will be a double arrow icon in the header like this:

enter image description here

Click it, and select the field "Display Name" and the names should show up in a new column.

Hit Close & Apply.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.