http://www.biinsight.com/quick-tips-connecting-to-excel-files-stored-in-sharepoint-online-from-power-bi-desktop/
Quick Tips: Connecting to Excel Files Stored in SharePoint Online from Power BI Desktop