Could Someone just give me an idea that this will work in Office365 PowerBi/Power Query Sharepoint List RRS feed

  • Question

  • Im easily confused but for some reason I am having trouble with the following scenario

    I have created an Excel Workbook with Power Query that queries an Online (365) SharePoint list . I would like to share the Excel spreadsheet through Power BI for Office 365 (which I have signed up). I would like to share the Excel so that when users open the report online they see the latest data . If not the latest , then at least (not optimal) see the data set from a scheduled refresh. Unfortunately , the refresh fails because I don't have a data source setup fore the online list. I tried but for some reason it forced me through on premise gateway setup which fails due to only two authentication methods.. Anon and Domain .. anyway, Im chasing rabbit trails. can someone help? thanks 

    Tuesday, November 18, 2014 3:54 PM