Forum Discussion

jterrans2's avatar
jterrans2
New Member
7 years ago

Importing Issues from Sharepoint LIst to Power BI

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 a...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

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's avatar
    jterrans2
    New Member
    7 years ago

    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