Scheduled Refresh has Stopped Working

[dbruch]

Hello everyone, I am new to the Power BI community and need a hand with this.  I use Power BI for all of my reporting and have never run into any issues before.  For most of my reports, I use the online version of Power BI to display visualizations from spreadsheets stored on our SharePoint page.    

The report having an issue was created in Power BI Desktop and also pulls from a SharePoint excel file (an excel survey, to be precise).  It is scheduled to refresh once per day, and worked with no issue for the first week.  Suddenly, one day the refresh failed.  I tried to manually update, but that gave the same error.  As far as I know, nothing has changed on my end, so I don't understand why this suddenly stopped working.  

Here is the error message:

Something went wrong

There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.

Data source type  SharePoint

Processing error  Web.Contents failed to get contents from xxxx/_api/web/lists/getbyid('d51c381b-9c1d-4127-93ec-aedd9351a776')/RenderListDataAsStream' (500): Internal Server Error

Cluster URI  WABI-WEST-US-redirect.analysis.windows.net

Activity ID  cdcb8f49-ab20-4a06-a557-6ef03e515359

Request ID  bafe2f32-48e8-4b8a-9faa-cb400831ce9e

Time  2017-04-24 12:17:55

If anyone has any insight into what has caused this change, I would greatly appreciate it.  Let me know if I need to provide more information to diagnose the problem.

Thanks!

Dan 

[v-yuezhe-msft · Accepted solution]

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

[dbruch]

Interestingly, [ApiVersion=15] was in the advanced editor code, but the issue sorted itself out somehow before I got to delete it.  Refreshing just fine now.  If it happens again, I'll be sure to check on that, thanks!