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.
