• 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:

• 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.

Our tests have shown that applying series filter options in Power Query may not work in all cases. To work around this problem, you can use Browser page to construct an OData URL that queries only the selected Series ID’s. :

• Use Browser page to navigate datasets / categories and find the series you are looking for and build your filtered URL. Copy the constructed URL.

• Now connect to OData feed as you do with URL’s in each dataset but this time enter your filtered URL and proceed. You will see only the data related to your selected series that you can load into your sheet.

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.

If you have connections already built with no access key and want to add yours then you can follow these steps. A reminder that an access key is an 8 alpha-numeric string appended with underscore (_) to the end of an OData URL. Like http://eiaconnector.oilstat.com/odata/petroleum_xxxxxxxx (you need to replace xxxxxxxx with your access key from Settings page) :

• Edit your connection using Edit from the context menu that is accessible with a right-click. If you can’t see Queries & Connections window you can invoke it from Data ribbon.

• Now pick Advanced Editor and add in your access key – notice the prefix underscore character. Save and apply your change after.