...
You can now run filters on the data as required or write your transformations using the M Language using Query Editor's Advance Editor
...
Date/Time Filter
You must add a Time/Date Filter
...
, if not the search will not end and will time out, you will see an error message
...
To add a Date/Time filter you can
Click the arrow next to heading that you want to add the filter to.
...
There is a variety of options you can use, I find it best to use the “Between” Options
Then select the dates you wish the report to cover
...
8. Once all the required Filters are run → Close & Load the data to Excel
...
Clear the permissions and try again
Click here for instructions
2. Clear the Cache if still an issue after clearing the permissions
...