Our connector can apply date filter options at the source only returning the rows with the date criteria you have in mind. Follow these steps to accomplish this:
• Access Power Query Editor either by clicking on Transform when you are on the Navigator page or if you already have your dataset loaded, go to Data tab > Queries and Connection (from ribbon) > select your Query from right-hand pane and select edit.
• Apply Your Date Filter on the Power Query page by first selecting the Date column and then click the Filter. You can now use the following three filters: After, Before and Between. Notice that only these three date filters have been implemented and can be used at this time:
Note: Filter option can only be applied to the core EIA datasets which excludes Drilling Productivity Report (DPR) and Baker Hughes Rig Count Report datasets.