Use an OData Feed to Pull Data into Excel using Power Query and Power Pivot HD
This tutorial demonstrates the use of an OData feed to pull data into Excel 2013. The OData feed is accessed with Microsoft Power Query and then added to a Power Pivot model for use on a fun and interactive dashboard.