How-to
• From the Data tab select Get Data on the ribbon and then proceed to From OData Feed option:
• Enter the URL of the category you are interested in and click OK and then on the Navigator dialog window you can search and find the subcategory that you are looking for and load all the data series in it. There is also an option to select multiple categories:
• Download and install the latest version of Microsoft Power Query following this link:
https://www.microsoft.com/en-us/download/details.aspx?id=39379
** Unless you are sure that you have a 64-bit installation of Excel, choose the 32-bit version of the install base.
• Check to be sure the Power Query Add-In is enabled. Access Excel Options from File > Options menu then navigate to Add-Ins tab, select COM Add-Ins from the Manage selection and click Go. On the COM Add-Ins dialog window check the Microsoft Power Query for Excel option and then click OK:
• Follow by selecting the From Other Sources > From OData Feed menu on Power Query
** Notice that you need to use the Power View tab and not the Data Tab in Excel 2010 and 2014. Power Query complies with the latest version of OData we currently use – that is OData V4.
• Enter the URL of the category you are interested in and click OK and then on the Navigator dialog window you can search and find the subcategory that you are looking for and load all the data series in it. There is also an option to select multiple categories: .
• From the Home tab select Get Data and then OData Feed. If it is not listed, then you can access it from the More menu item and then follow by selecting the Other category:
• Enter the URL of the category you are interested in and click OK and then on the Navigator dialog window you can search and find the subcategory that you are looking for and load all the data series in it. You also have the option to select multiple categories:
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.
When you apply the checkbox to load multiple categories, you will see concurrent connections loading the data on the pane that usually opens to the right. Tables are not built automatically based on the data loaded. You need to pick the connections individually and load the data for them:

• Selecting multiple categories.
• Right-click on the connection and pick Load To. Now you have the option to load the data to various destinations.