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.