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 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!

Need Help

2 Replies

  • 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