Error while scheduling refresh for reports on Power BI report server
While trying to schedule a refresh for any report on my report server, the following error is returned (Screenshot attached). All data source verifications are sucessfull and the report is manually refreshed without errors. The older schedules are working perfectly but I am unable to schedule a new one. Please help
Report refresh failures.
An error occurred while processing the data in the dataset. Refresh failed: Dashboard_New_2 has failed to refresh. Failure details: Query execution has resulted in error (0x80131500): Partial query failure: 0x80131500 (message: 'One or more errors occurred.: : : ', details: 'Source: Kusto::CachedStorageObject'). [0]Kusto.Data.Exceptions.KustoDataStreamException: Query execution has resulted in error (0x80131500): Partial query failure: 0x80131500 (message: 'One or more errors occurred.: : : ', details: 'Source: Kusto::CachedStorageObject'). Timestamp=2021-08-18T12:26:09.5197870Z ClientRequestId=KPBI;a0f4d171-990c-4b13-b99e-322581999a07;07fdacce-7efb-48d4-a138-15ace0f0fb7f;309a646b-4a67-4d08-ab68-e619b3c4e57b ActivityId=ce20e192-f8fb-45e7-890c-0652e9ee058c ActivityType=PO.OWIN.CallContext ServiceAlias=AZCRP MachineName=KEngine00000T ProcessName=Kusto.WinSvc.Svc ProcessId=9388 ThreadId=14632 AppDomainName=Kusto.WinSvc.Svc.exe ActivityStack=(Activity stack: CRID=KPBI;a0f4d171-990c-4b13-b99e-322581999a07;07fdacce-7efb-48d4-a138-15ace0f0fb7f;309a646b-4a67-4d08-ab68-e619b3c4e57b ARID=ce20e192-f8fb-45e7-890c-0652e9ee058c > PO.OWIN.CallContext/ce20e192-f8fb-45e7-890c-0652e9ee058c) MonitoredActivityContext=(ActivityType=PO.OWIN.CallContext, Timestamp=2021-08-18T12:25:30.5340865Z, ParentActivityId=ce20e192-f8fb-45e7-890c-0652e9ee058c, TimeSinceStarted=38985.7005 [ms])ErrorCode= ErrorReason= ErrorMessage= DataSource= DatabaseName= ClientRequestId= ActivityId=00000000-0000-0000-0000-000000000000 UnderlyingErrorCode=80131500 UnderlyingErrorMessage=Partial query failure: 0x80131500 (message: 'One or more errors occurred.: : : ', details: 'Source: Kusto::CachedStorageObject') Next refresh for Dashboard_New_2 is scheduled for August 19, 2021 12:00 UTC.
Scheduled Refresh Error
When I go to Site settings> Schedules, I keep getting an error message, "An error has occured. An error occured within the report server database. This may be due to a connection failure, timeout or low disk condition within the database." I have resized the default databases reports and reporttemp dbs to no avail.Scheduled report ran 1 hour late
Today, all of my scheduled reports all ran 1 hour after their scheduled time. We switched to daylight savings time over the weekend. How do I fix this going forward? For example: a scheduled report for 8:45 AM actually ran @ 9:45 AM. It is still scheduled to run @ 8:45 AM.Power BI Report Server unable to Refresh Reports
Hi Guys, We have an instance of Power BI Report Server (Oct 2017) version. There are 5 reports scheduled to refresh from the Oracle Data Source daily at 6 am. On the Schedule Panel in Site Setting, it shows the scheduler is running and refreshing every morning (Pic 1) But the actual report is not refreshing and the schedule on the report shows not refreshed (Pic 2). I have checked the log files on the server but unable to find anything specific to schedule refresh fail. SQL Server Agent is Running on the Servers and there are no errors on the Event Logs for SSAS. How do I find out the cause of this error? Is there a place to check the execution of each Schedule / Report? Thanks
Schedule issue: An item with the same key has already been added
Hello, we use the Power Bi Reporting Service October 2017 and we can refresh the Reports in Power BI Desktop but not scheduled on the Reporting Service. We got this issue: Data refresh failed. Please try again later or contact you administrator. SessionID: df130cf6-f7e1-482f-8264-131ef7dcbca6 [0] 0: An item with the same key has already been added. Some reports finished well, but all of the failed reports have for example merged DataSets with an Analysis Connection / SQL Server Connection. We use the 14.0.600.442 Version. Has anyone a solution for this ?
