Forum Discussion

jbrines's avatar
jbrines
Advocate III
5 years ago
Solved

Displaying Sharepoint List user name issue

Hi Guys,   I followed the solution from a few years ago below. When I get to part there and create a releationship it doesn't seem to display the name just shows the ID number   1). Import ShareP...
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    5 years ago

    Hi, jbrines 

     

    I think you have some confusion about the premise of create a relationship. They had better be of the same data type,The relationship between id and name is inherently conflicting. So there is a problem.

    Reference: Create and manage relationships in Power BI Desktop - Power BI | Microsoft Docs

    If it doesn’t solve your problem, please feel free to ask me.

     

    Best Regards

    Janey Guo

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-janeyg-msft's avatar
v-janeyg-msft
Community Support
5 years ago

Hi, jbrines 

 

I think you have some confusion about the premise of create a relationship. They had better be of the same data type,The relationship between id and name is inherently conflicting. So there is a problem.

Reference: Create and manage relationships in Power BI Desktop - Power BI | Microsoft Docs

If it doesn’t solve your problem, please feel free to ask me.

 

Best Regards

Janey Guo

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • jbrines's avatar
    jbrines
    Advocate III
    5 years ago

    v-janeyg-msft 

    Yes I am confused, sorry.

    I am trying to create a report from a sharepoint list that will show how may items were assigned to someone

    I am trying to create a report to show how may items were created by someone

    Also I am trying to create a report on how many were assigned to a Sub-Contractor.

     

    John.

    • v-janeyg-msft's avatar
      v-janeyg-msft
      Community Support
      5 years ago

      Hi, jbrines 

       

      I don't seem to understand the connection between your ideas and create relationships. Can you explain it more clearly?

      I suggest that you can create a relationship based on the same field, such as the 'contenttypeid' in your two tables.

       

      Best Regards

      Janey Guo

       

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.