Scheduled Refresh has Stopped Working

Hi dbruch,

Are you able to refresh the report created using the Excel file in Power BI Desktop? And how do you connect to the Excel file in Power BI Desktop?

I make a test that use Web entry in Power BI Desktop to connect to Excel file stored on SharePoint Online, create a simple report and publish the report to Power BI Service. After I update data in the Excel file, I can successfully refresh the report in Power BI Service. The code generated in Advanced Editor of Power BI Desktop is as follows.

let
    Source = Excel.Workbook(Web.Contents("https://XXXX.sharepoint.com/sites/patrick/Shared%20Documents/Book1.xlsx"), null, true),
    Table1_Table = Source{[Item="Table1",Kind="Table"]}[Data],
    #"Changed Type" = Table.TransformColumnTypes(Table1_Table,{{"Column1", type text}, {"Column2", type text}, {"Column3", Int64.Type}})
in
    #"Changed Type"

Could you please share the codes in your Advanced Editor? Based on my reserach, the above error could occur when you add [ApiVersion=15] in the source code in Advanced Editor, if that is the case in your scenario, please remove [ApiVersion=15] from the code, re-publish Power BI Desktop file and check if refresh works in Power BI Service.

Thanks,
Lydia Zhang