Unable to fetch filter values./Calculated Field inavlid syntax

Q&A
,
1

Hello Team,

Today I encountered a confusing issue with one of my Direct Query datasets. Here’s the context:

  • I’ve been using this dataset to power a table visual for the past 3 months without any issues.
  • Suddenly, I’m now seeing the following errors:
  1. Filter Error: “Unable to fetch filter values. Refresh later or use the ‘Custom filter list’.”
  2. Visual Error: “Your calculated field has invalid syntax.”

What’s puzzling is that there are no calculated fields in this table—only direct columns from the dataset.

I’ve tried refreshing and rechecking the dataset, but the issue persists. If anyone has seen something similar or has suggestions, I’d appreciate the help.

Thanks in advance!

Screenshot 2025-04-10 114558
Screenshot 2025-04-10 1145581118×416 44.8 KB

2

Hi @Karthika_G

Try debugging by adding a new visual in your analysis and include fields one by one.
This could be due to some data issues in your fields.

Regards,
Giri

3

Thank you @Giridhar.Prabhu. I tried to debug. No problem with any columns when I add columns one by one. But When I try to create filter with id (integer) column it is giving issue.

4

Can you share the details of the error you are getting?

5

Got solved @Giridhar.Prabhu . But I don’t know how because I did nothing, automatically the error solved :thinking:. How is this possible? :roll_eyes:

6

Hi @Karthika_G,
It’s hard to say exactly why it may have started working without anything done to it, there may have just been a small bug in the system.
If it ends up happening again, I would suggest creating a support ticket so that you can report the erratic behavior to the AWS support team.

Thank you!

7

Thank you @Brett , I will definitely do that.