Import from Excel with Data Type columns doesnt matter

Hey Prodingero ,

It seems like the issue arises because Power BI Power Query is unable to directly recognize or handle custom data types created in Excel (like the “Person” column with a List data type). Power BI does not yet support extracting or directly manipulating custom data types created in Excel when importing the file. Few possible workarounds:

1. Convert the List to a Recognized Type: Before importing the file into Power BI, try to expand the “Person” column in Excel to a simpler type (e.g., a text or number column). You can do this by selecting the List within Excel (using Power Query) and expanding it into individual fields or values. This way, Power BI can import it more easily.
2. Pre-process the Data in Power Query: If you can’t modify the Excel file, you can load the file into Power BI, and then in Power Query, try to expand the “Person” column manually by using the “Expand” option or transforming the data into a simpler format that Power BI can handle.
3. Use a SharePoint List Instead: Since SharePoint lists work better with List-type columns, if possible, you could consider migrating this data to a SharePoint list where the List type is more natively supported.

For Detailed Information:

Create a custom data type in Power Query

How to fix Power Query errors

Power BI SharePoint List Integration

If you found this solution helpful, please consider accepting it and giving it a kudos (Like) it’s greatly appreciated and helps others find the solution more easily.

Best Regards,
Nasif Azam