Datalfow refresh ignores filter

Hi all,

I hope someone can help. I have Pro license and working on getting a premium or ppu license. I have one specific dataflow that pulls from a SQL database and within my query I have the data filtered specifically by the RFP date after 1/1/2021. I have the dataflow on a scheduled refresh but for some reason when it is on a scheduled refresh, it ignores this particular filter and only provides the first 2021 data only.

It is a weird because I am pulling from the same SQL database but different tables and don’t have any issues. It is only when I pull data and filter from the Deals table.

Can someone shed some light? I really appreciate it.

1 Like

Total shot in the dark, is the RFP Date in the correct date format?

The format is setup as Date. Thanks DavieJoe for your input. I will do a workaround.

much appreciated