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

[Robot33]

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. 

[Robot33 · Accepted solution]

Thank you very much! This was helpful. Didn't know about those options. However, I ended up using this method here: https://whitepages.tygraph.com/2016/07/simplified-method-working-sharepoint-data-power-bi/ 

Thank you @jcalheir! 

[jcalheir]

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