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: