Unable To Schedule A Refresh If One Or More Data Sources Are A File
I have two data sources in a report. File SQL Since I have a File data source which can not schedule a refresh, the SQL data source is now also unable to schedule a refresh. This is a clear bug as the SQL data sources should still be allowed to use a schedule.
Power BI Report Server - Scheduled refresh does not work
Hi there, We have a problem with PBIRS and its refresh schedule. All new assigned schedules don't work. In debug mode we see errors in RSPowerBI_*.log files: |DEBUG|67|Exception during db accessSystem.Data.SqlClient.SqlException (0x80131904): The INSERT statement conflicted with the FOREIGN KEY constraint "FK_SubscriptionHistory_Subscriptions". The conflict occurred in database "ReportServer", table "dbo.Subscriptions", column 'SubscriptionID'. The statement has been terminated. Any ideas to resolve? Thanks in advance.
Schedule Refreshed Failed ("Invalid Credentials" but authentification are correct)
Hello all! We have some kind of strang behavior with schedules at our Report Server at the moment. Their are Schedules who cant refresh because the SQL-Source Credentials are invalid. If we check the connection string we dont get any error. We use an Service Account and sometimes with different Reports we get this message and cant understand why. We tried to replicate the error when we planned a schedule for the same time with the same account but it worked well. Can somebody explain this behaviour or knows any solution for it? Thank you so much for your help!
Problems with schedule resfresh
Hi everyone! I have refresh schedule at my reports on PBIRS and it worked good, before I set the second report server instance for mobile server (I used this instruction Configure a Native Mode Report Server Scale-Out Deployment - SQL Server Reporting Services (SSRS) | Microsoft Learn) After that I faced a problem that my schedule started to go sometimes by my first server, and sometimes by my second report server, and if it go by the second, there are always errors on the moment of DataRefresh ItemAction I tried to follow this steps from Turn Reporting Services Features On or Off - SQL Server Reporting Services (SSRS) | Microsoft Learn And frankly speaking amout of Second(mobile) tries of refreshing became less, then it was, but not zero and i still can see them and thereafter errors in refresh schedule thanks in advance for helpingproblems with scheduling updates
Good afternoon. I have encountered such a problem that updating reports on a schedule causes such an error, despite the fact that manually clicking on the update, it turns out without problems. The data is taken from the PostgeSQL server with the help of conection to data gateway On-premises data getaway because i need VPN to have access to data. please tell me what the problem may be and how to fix it?Report does not refresh on schedule
Hello, I have configured an on-prem report server with the Oct 2020 release. I have a report developed using the same release that pulls data from a sharepoint list, approx 30 rows total, no calculations or metrics. Just a simple dump of three attributes to a table. The report refreshes in Desktop without issue as well as within the portal. However, if I attempt to schedule it or refresh on demand in the scheduling interface it does not refresh. The message in the ...\Microsoft Power BI Report Server\PBIRS\LogFiles\RSPowerBI log file is: 2020-11-18 08:00:07.7366|ERROR|61|Error Processing Data Model Refresh: SessionId: 66bda523-cb7a-4055-adc0-c0059efeccfa, Status: Error Failed to refresh the model, Exception Microsoft.AnalysisServices.OperationException: Failed to save modifications to the server. Error returned: 'COM error: System.Core, Sequence contains no elements. The current operation was cancelled because another operation in the transaction failed. I am using a service account to connect to sharepoint and the rights have been verified. As I mentioned it does refresh successfully using the service account outside of the scheduling interface. Any suggestions would be appreciated. Thank you. Jeff
No data shows after after refresh
Hi All, I saved my report to the Report Server, and scheduled a refresh. After refresh as opened the report there were no data in the visuals, everything were blank, but it was written that the refresh was successful. I saw some articles which were about boolean values in filters, but I don't have any in the report. Do you have any idea how to solve this problem?? Many thanks in advance! Mate
