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. 🙂
problem with scheduled refresh execution
Hello everyone, I have a problem with a scheduled refresh. So I scheduled a refresh at a specific time. But the Report Server is not execution at the scheduled time, but earlier. When I delete the refresh and recreate it, it will run as it should. Has anonye ever exeperienced such a problem and knows how to fix it?
Report Server Scheduled refresh issues
Working with Power BI report server september 2022. We have a bunch of reports with scheduled refresh. I would like to understand why some of the refresh plans stays stuck on status Refreshing in progress? Other reports do refresh but for exemple if they are scheduled for 7:00 am , the status is ends up completed but last run is many hours after the time scheduled. I have done lot of research many point out to the way the reports are built , but my issue with this is when you test in the Power BI Desktop app you do a manual refresh , this works fine and updates within a minute. I would expect same result on the server... Please help
Can't refresh reports. On-Premise Gateway / DNS Problem?
Hello, I have a problem with data refresh through an On-Premise Gateway. Both planned and manual refresh are causing issues. All reports are affected. It usually takes too long to refresh (over 10 min.) and then this error code is shown. There were times when I could refresh my reports manually today, but the issue kept showing later again. I tested reports with data from different SQ servers. Then I created a new gateway on my pc and turned off the gateway we have in our virtual power bi server. The issue remained. I started to track the data traffic and apparently the gateway is sending data to these Microsoft domains: g0-prod-fra21-001-sb.servicebus.windows.net g1 g2 ... g15-prod-fra21-001-sb.servicebus.windows.net Some of these domains return a local IP address, tested with different public DNS. Currently, g8 is returning 10.218.0.23, g9 returns 10.218.0.24, g15 returns 10.218.0.30. Others seem to have a public IP, like g0 with 51.116.232.39 for example, and the traffic goes through. I'm assuming this might be the reason sometimes the refresh works and sometimes it doesn't. Is someone else having a similar problem?Scheduled Refresh Plan for Power BI Server connected to Maria DB
Hi all, we are working on a Report on Power BI Server connected to a MariaDB database through the ODBC Connector (as described on their website) as "Import" (not Direct Query). We cannot setup the Scheduled Refresh Plan, it seems impossible to setup under these conditions. IT is shown the following error under the "Scheduling Update" tab it gives the following error: "Planned data update is not available for reports. The report does not contain defined external data connections or uses an unsupported data source" Do anyone have a solution for this issue? Many thanks, A
