We’re using Excel/Power M to connect to a form and pull all submissions into a table. This form contains many, many needs assessments and with Power M each refresh downloads all submissions and takes quite some time for users. Obviously the submissions can be filtered after the query has refreshed, but is there a way to write the Power M query to filter the submissions (between two dates) before downloading them to Excel?
We currently use Excel to connect to the XLS. Doing some research, it appears that maybe it’s possible to filter by connecting to the JSON (Filtering API query results by date) however when using Power M I can’t seem to reformat the records into a table (see screenshot). It’s also not clear if it’s possible to filter between two dates with this method.
Any support would be really, really appreciated! I’m a bit out of my depth here, so thanks in advance.