Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Expression.Error: Cannot convert a value of type Table to type Table

Hi,   Here's my case. Thanks for any help on this.    I was first combining Excel files in a query. Then, I wanted to merge this query with a query coming from an OData feed. Here I got a Formula...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi,

     

    I found out what was going on. It was simple in fact.

     

    Both column I was trying to merge were not the same data type so I changed both to Text.

     

    Regards,

artemus's avatar
artemus
Microsoft Employee
6 years ago

Are you using Analysis services? If so, it has some functions that only work on a cube, which is a specialized table. If you staged your data to a differnt datasource, then this additional functionality is not avialable.

 

Also, if you are not concerned with the possiblity of leaking privacy data from one data source to another, you can turn off the privacy checks in the options, which I think will remove this error.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi artemus,

     

    I'm not using Analysis Services and for now turning off privacy settings is the last option I want to consider.

     

    Regards, 

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thank you for your second response. I've changed data privacy option and it's work now