Install SQL Server BI Features with SharePoint 2013 (SQL Server 2012 SP1)

http://technet.microsoft.com/en-us/library/jj218795.aspx

Announcing Power BI for Office 365

http://blogs.office.com/b/office-news/archive/2013/07/08/announcing-power-bi-for-office-365.aspx

Create Power View Reports in SharePoint 2013

http://www.mssqltips.com/sqlservertip/3005/teach-business-users-how-to-create-power-view-reports-with-sql-server-data-sources/

Extract from Excel using ODBC

https://www.simple-talk.com/sql/database-administration/getting-data-between-excel-and-sql-server-using-odbc--/

Using Parameters in Power Query Extracts

http://www.sqlservercentral.com/blogs/dknight/2013/08/07/using-parameters-in-power-query-extracts/