Removing of filter causes error

[alks_skla_f]

Hello,

I have a table visual. There is Fetch filter option is chosen for column "Data Source Flag":

When I remove the filter, I have this error:

Does anybody knows what it mean?

[v-hashadapu]

Hi @alks_skla_f , Hope you're doing fine. Can you confirm if the problem is solved or still persists? Sharing your details will help others in the community.

[v-hashadapu]

Hi @alks_skla_f , Thank you for reaching out to the Microsoft Community Forum.

We find the answer shared by @Shahid12523  is appropriate. Can you please confirm if the solution worked for you. It will help others with similar issues find the answer easily.

Thank you @Shahid12523  for your valuable response..

[v-hashadapu]

Hi @alks_skla_f , hope you are doing great. May we know if your issue is solved or if you are still experiencing difficulties. Please share the details as it will help the community, especially others with similar issues.

[pankajnamekar25]

Hello @alks_skla_f 

The issue occurs because when the filter is removed, additional values in the Data Source Flag bring in data with schema differences or unsupported queries that BigQuery can’t process. The solution is to simplify your Power Query steps and isolate or standardize those flag values so the query remains compatible across all cases

If my response helped you, please consider clicking
Accept as Solution ✅ and giving it a Like 👍 – it helps others in the community too.


Thanks,


Connect with me on:

LinkedIn

[Shahid12523 · Accepted solution]

✅ When you filter for "Fetch" in Data Source Flag, the visual works because only compatible data is queried.
❌ Removing the filter includes other flags like "Fetch Sales History" or "Subscription Fetch", which trigger a BigQuery ODBC error due to unsupported query syntax or schema differences.

Fix: Test each flag separately, simplify Power Query steps, and avoid complex constructors or incompatible expressions that BigQuery can't handle.