Forum Discussion
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...
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
Microsoft Employee
Microsoft EmployeeAre 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.
Thank you for your second response. I've changed data privacy option and it's work now