Importing Issues from Sharepoint LIst to Power BI

[jterrans2]

Hi Everyone, I need help with an issue I am having importing a Sharepoint LIst. I have a column Type that is a Person or Group I have titled Employee. The List settings are for it to be People Only and All Users. It is working fine in the List and in PowerApps. When I Get Data it comes in as the employee ID number and not the employee name. Does someone have an idea what is going on? Much appreciated!

[v-juanli-msft]

Hi @jterrans2 

I can't reproduce your problem, it is much appreciated of you to clear me.

When I Get Data it comes in as the employee ID number and not the employee name. 

Which column is it?

Does it refer to the following column?

I have a column Type that is a Person or Group I have titled Employee.

Could you show example data or more other details?

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jterrans2]

Thank you very much for having a look at this for me!

Here is the Sharepoint List and the Columns I am referring to:

Here is how I have the Column Type and Settings set up: 

And here is how those Columns get imported into BI. With ID numbers and not Names:

Let me know if you need anything else, and thanks again!

Terran