Schedule runs in advance (before specified time)
Hi. I have scheduled a report as follows: I have added a card in report which displays date and time of last report refresh, Today I was looking at the report and found out that it has had refreshed today, before 8:15AM As report is set to refresh every 3 hours, it's apparent that report is refreshed out of specified hours. I tried to investigate more and found related SQL Server Agent job. I was unable to open job's schedule, as SSMS gives me this error: So, I scripted job to see what's inside. Thi is the schedule part: This confirms that job should not run before 8:15AM. But there are more strange things here. active_start_time and active_end_time parameters have abnormal values compared to each other. End time comes before start time! Furthermore, why does SSMS give error on freq_subday_interval value? It is set to 180 and doesn't seem strange. Can someone help me on this behavior please? Regards, Mohamamd
ISSUE with connections, gateways and scheduling automatic refresh
Dear, I am making multiple reports in power BI using an Excel in the cloud. However at one point instead of having one connection, it made a connection to the cloud and some sort of gateway, even though I referred to the same excel in the same location. The issue with this is that it caused the option to schedule a refresh to dissappear. What happened and how can I solve it so it works as before. Secondly, I will have to transfer these power BI files and connections to another account, since I referred to the excel using the link to the cloud and the other account has access to the same cloud, will this go smoothly? Thank you! Kind Regards. Screenshots below!
Unable to schedule refresh
Dear All, We have multiple reports hosted on Power BI Report Server version (September 2022). Somehow without any modifications some of the reports are loosing the schedule refresh. If I download and upload again, this is working fine. But seems after sometime issue is coming back. All I can see is this message. Stored credentials for this report are missing. Please go to the Data Sources page for this report and set your credentials for each data source to enable scheduled data refresh. Any idea how to resolve this. TIAFinally Schedule Refresh works on Power BI Report Server September 2023
Last week I installed the new version - Power BI Report Server September 2023, after each new version I test Schedule Refresh. After this version for a first time Scheduler Refresh works! I have managed to set it up for all my reports and data sources. Just for web source – it does not work. So happy now, I have automated PowerBI reports. Just wanted to share this, because I'm sure that many users have similar problem with previous versions.Report Server Schedule Refresh stays in Refreshing status
Hello, I have setup a Schedule Refresh in one PBI report on PBI Report server Premium. So I have a SQL agent job created with powerBIServer user on Report Server and running at the scheduled time interval and shows status Succeeded. But Data is not refreshed and also status is showing "Refreshing". Please see the attachment.. Any idea ?
Schedule refresh
I have an shared excel document stored on SharePoint online which I have created a report from PowerBI Desktop. I can refresh the data successfully in desktop. The problem is that once I have published it to servicewhile running a schedhule refresh,it giving me an error "Data source errorExpression.Error: The key didn't match any rows in the table.. Key = <ccon>"
Can not create or assign a schedule refresh plan to a report
Hi all, We have Report Server January 2022 release version 1.13.8054.40.361(Build 15.0.1108.153). I'm able to create a new shared schedule from site setting. However, i can not create or assign an existing shared schedule to a dashboard. I get an error message: An error has occurred. Something went wrong. Please try again later. The connection to the data source is set and connectivity is successful. The error in RSPortal log file shows: |ERROR|132|OData exception occurred: System.Net.WebException: The request failed with HTTP status 401: Unauthorized. The report server is configured to use a virtual service account as a service account. For report server database the credintials are set to SQL account and both the sql account and service account have the proper roles in database. authentication types in reportserver.config file are set as below: Can you please help me to resolve this issue ?
