http://biinsight.com/connect-to-power-bi-desktop-model-from-excel-and-ssms/
Connect to Power BI Desktop Model from Excel and SSMS