Query works in SSMS but I egt an error in a PowerPivot query

Ken Cahill 1 Reputation point

I have searched the questions but couldn't find an answer. I have a query I tested in SSMS and it works fine but running the same query in PowerPivot I get an error. It is a simple table in Access that only has 8 columns.


When I run a query on the table in SSMS it runs great.


And Produces


When the same query runs in PowerPivot I get an error


The query without the calculated column works fine


Any ideas on what I am doing wrong?

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
36,565 questions
0 comments No comments
{count} votes