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

Ken Cahill 1 Reputation point
2022-03-04T11:46:06.703+00:00

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.

180133-image.png

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

180049-image.png

And Produces

180065-image.png

When the same query runs in PowerPivot I get an error

179998-image.png

The query without the calculated column works fine

180117-image.png

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