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. 🙂
How to change the data source of a model and run the existing queries?
I created a model based on excel file. after connecting to the data source (which is the his excel file) I created several steps and measures. Now I realized that it could be better to used a pivot table (which is in anotehr excel file) as a data source, instead of the first excel file. The layout is the same in both excel file and pivot table file (1st and 2nd file). When I change the data source to the pivot table excel file, it gives me error and I cannot connect it properly nor use the steps that I created beforehand. Error presented when trying to load new data source: "The key don't match any rows in the table". How to make that? Thanks, Diego
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?