Forum Discussion

Valdirf's avatar
Valdirf
Regular Visitor
2 years ago

Expression.Error to expand a list

I have a List type field in a PowerBI table. When I expand this field in Power Query and apply the changes, I receive the following message:

OLE DB or ODBC error: [Expression.Error] Parameter was expected to be of type Text.Type or Binary.Type.

 

I would like to know what could be happening in this expansion?

2 Replies

  • Valdirf's avatar
    Valdirf
    Regular Visitor
    2 years ago

    Hi, Ibelndlin. Thanks for answer. THe issue was related a change in the database. Once we updated the queries for avoid old data (with the old collumns) the report works

     

    Thanks for you attention