Scheduled refresh is failing when data source is "Excel.Workbook(Web.Contents("
My dashboard sources are mostly open sources (web), one of them is an excel with multiple sheets: "https://www.bag.admin.ch/dam/bag/de/dokumente/mt/k-und-i/aktuelle-ausbrueche-pandemien/2019-nCoV/covid-19-datengrundlage-lagebericht.xlsx.download.xlsx/200325_Datengrundlage_Grafiken_COVID-19-Bericht.xlsx" According to Microsoft Docs, a gateway is required for .xlsx, therefore I have set up an on-premise one and it runs correctly. Besides this, I can easily do a manual refresh. But using the scheduled refresh i receive the following error message: XY has failed to refresh. Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support. {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"File contains corrupted data."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataFormat.Error"}}],"exceptionCulprit":1}}} Table: XY. Has anyone experienced a similar situation? How could i fix that? Thanks a lot for your help, i am kinda lost. 🙂
Sharepoint (On premise) Excel source refresh not working on Power Bi Reporting server
I am using excel as a data source which is placed on a SharePoint (On premise) using Get data --> Web . I upload report to power BI report server and make changes to the data source (excel), the data does not get refresh when i click on refresh button on the report. Will it work only in case of schedule refresh and not when we click refresh manually?