Forum Discussion
Power Query Date Filter missing dates
I am in charge of tracking a covid check-in database for my org, and I have a spreadsheet that has been working for weeks. It's now failing on 2 fronts, and I can't see why at all. The check-ins...
If refresh queries one by one in Power Query editor do you see any errors with that?
No. Haven't seen errors. I may check that specifically, I just did a test new sheet which has worked.
I am not sure on the reason, but it seems it doesn't like not finding any data.
So if I do the date filter on the initial PQ, it seems to mess things up, but if I do the PQ from folder and just dump it into the spreadsheet then PQ that with the filter it all works.
I am not sure on the reason, but it seems it doesn't like not finding any data.
So if I do the date filter on the initial PQ, it seems to mess things up, but if I do the PQ from folder and just dump it into the spreadsheet then PQ that with the filter it all works.