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. 🙂
Model can not be refreshed for files not mapped to a network share
Hello, After updating Power BI Reprort Server to vesion 1.9.7627.11028 (October 2020) there is one an error when I try shadule refresh a Power BI report. I found that Path names in data sources on Server and data sources in data sources setting in Power BI File are different from Mashup queries pathes names and folder name in Explorer. Real path to the folder in Explorer is ADDITIONAL INFOMATION Queries Structure is When I refresh the model in Power BI Desktop there is no problems.
Generic "Something's wrong with one or more fields" error on data refresh
I keep getting these errors on various reports, but only when they are uploaded to the server and then subsequently refresh their data. The visuals work fine in desktop and they work fine when initially uploaded to the report server, but randomly break when the data refreshes. My solution so far has been to just re-upload the report, which has worked most of the time, but I'd like to figure out what's causing this. Here's the error this time: Fields that need to be fixed Something's wrong with one or more fields: (OGP_DataSet1) ClosingsToHitGoal Please try again later or contact support. If you contact support, please provide these details. The "technical details": Request ID 23d87758-3cfb-9844-516d-966b29ec3351 Time Fri Jul 03 2020 10:34:01 GMT-0400 (Eastern Daylight Time) Service version/powerbi/libs ClosingsToHitGoal is a measure, and is working fine in desktop. It's simply a number minus COUNT() of a column, which exists and is working in the dataset.Cannot start Power BI Report Server after upgrade (August 2018)
Hi - I once again have an issue with the Power BI Report Server installation. Same issues as last time - however this time I would like a proper solution - last time I uninstalled the PBIRS causing all user info to be lost. When trying to start PBIRS from the Configuration Tool: System.InvalidOperationException: Cannot start service PowerBIReportServer on computer 'SRVESBSQLC3A01V'. ---> System.ComponentModel.Win32Exception: Access is denied --- End of inner exception stack trace --- at System.ServiceProcess.ServiceController.Start(String[] args) at ReportServicesConfigUI.Panels.ConfigurationPanelWithErrors.StartOrStopServiceTask(Boolean start, String serviceName) Error from the Service Manager: Windows could not start the Power BI Report Server service on Local Computer. Error 5: Access Denied This is critical as it is a production environment!
Something Went Wrong - Redirect.analysis
I have existing reports that I modify on my desktop and then publish to Power BI. This week, a couple of my reports won't update. When I publish from my desktop it says success and there are not issues when I update the app. However, when I look at the data it isn't updated and the dataset shows the following error message: Something went wrong An unknown error has occurred. Please try again. If the issue continues, please contact support. Please try again later or contact support. If you contact support, please provide these details. Cluster URI: WABI-US-EAST2-redirect.analysis.windows.net Activity ID: 65d3c22c-78f3-40e9-b6c8-2d5a6efe3c17 Request ID: cbd574e1-ba5e-41ca-9bba-b6797b1343a5 Time: 2018-09-13 18:32:51Z
