Forum Discussion

Robot33's avatar
Robot33
Regular Visitor
4 years ago
Solved

Problems pulling SharePoint data with Persona or Choice data type to Power BI

Hi everyone,

 

I'm using a SharePoint list to track work items. For consisntency I use the Person or group data type for "Requestor" and "Assigned To" and Choice data type for "Output type". 

 

I would like to build a PM dashboard with this data but when I connect to Power BI using Online Services, "Sharepoint list" i get a generic [Table] or [List] for anything that's not in a text of number data type. If I go ahead an visualise the values are not shown , I only see a "list" item in any X axis i make. 

 

Does anyone know how I can pull the actual values or the tables that have those values so I can build a model?

 

Thank you in advance. 

 

 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi

     

    You can use this connection in powerquery in order to expand the fields who retrieve lists or tables.

     

    You will be provided with the option bellow

     

     

    Kind regards,
    José
    Please mark this answer as the solution if it resolves your issue.
    Appreciate your kudos! 🙂