"schedule refresh"
5 TopicsScheduled refresh randomly failing every day recently with Data Source Error
Hi, I have couple PBI reports with data source from one sharepoint site, and they were refreshed successfully in past years until recently. The scheduled refresh randomly failed on multiple reports with below error message: Data source errorDataSource.Error: SharePoint: Request failed: Unable to connect to the remote server. Microsoft.Data.Mashup.ErrorCode = 10122. Microsoft.Data.Mashup.ValueError.DataSourceKind = SharePoint. The error is not happening on every refresh, around 80% of refreshes are successful; The error is not happening for every report with the same datasource, 80% of the reports are still fine, not sure what caused this issue, quite annoying. Thanks in AdvanceSolved1.2KViews0likes4CommentsWhere to view refresh history in report server web GUI
Hey All, As the admin, I would like to view refresh history of reports in the Power BI Report Server Web Gui? I found this page in MS documentation that explains how to view the current status of the latest refresh of a particular report, see HERE. However, This is not equivalent to an view that shows refresh history. I'm wanting an admin view that shows history of all refresh schedules and details about their executions. Please let me know if this functionality exists in PBI report server.Solved750Views0likes1CommentPower BI Semantic model refresh schedule is not updating the data
We have observed that the Power BI semantic model takes approximately 2 to 3 minutes to refresh the data during scheduled or regular refresh operations. However, we have also noticed that sometimes the same data refreshes in just about 10 seconds. Additionally, despite successful data refreshes, some updates are not immediately reflected in the associated reports. Could you please help us understand the specific factors or conditions that could cause such discrepancies in refresh duration? Furthermore, we would appreciate any guidance on best practices or steps to ensure that updates are always accurately and promptly reflected in the reports.Solved3.2KViews0likes5CommentsReport server On Premise refresh failed
Dear all i have a strange problem with our PBI On-Prem 2024.sept version server. A lot of reports are not refreshing sheduled, nor manual. It says "Completed Data Refresh", last run: a date from yesterday. If i add a new schedule, it keeps saying "Refreshing". in PBI server Logs i cannot see any serious or refresh related error. On MSSQL server Agent, all scheduled jobs did run with OK result. I installed the PBI server on another machine, copied the ReportServerDB and TempDB and the problem is still the same on the new server. What sould i check? Thank you for your help!Solved918Views0likes3CommentsHelp: Report Server Scheduled refresh not working
PowerBI Report Server Version: 1.21.9032.4573(V2024.09) Recently, I have noticed that some scheduled task refreshes have been consistently failing. The error message for the task is: SessionID: e47bdc6e-2ff4-4f43-a646-608829630077 [0] -1056505856: COM 错误 : Microsoft.PowerBI.ReportServer.ASEngineManagedRoot, Datasource dsn=hivecdp is not found. However this data source (odbc) does exist, and it can be successfully connected on the data source interface of the report. And it also connect successfully from the server. And not all scheduled tasks report errors, only some. After the error, I can manually start the task and it can start normally again This problem has been bothering me for several days. Please help me solve it together~Thanks836Views0likes2Comments