Hi everyone,
I’m trying to use the Dataverse connector to connect to a saved query (view) and apply a column filter so that I only bring back records modified each day (filtering on the Modified Date).
When I connect directly to the table, the column filter works exactly as expected. However, when I use a saved query, the column filters don’t seem to apply at all.
Am I missing something that’s required to make column filtering work with saved queries?
The reason I’m using a saved query is to reduce the number of columns returned, as the underlying table contains a lot of unnecessary and duplicate columns.
Any guidance or best‑practice recommendations would be appreciated.
Thanks in advance!