Hi Team,
Please pardon if this has ben already discussed. I have a schedule refresh that does not triggered automatically and we have to perform the maual refresh by clickin on the Refrehs Now everyday. This was working about 2 months ago but over suddent stopped. we have recreated the refresed several times to no success.
Steps already done:
I have rule out credentials since the refresh now works. And other reports with same credentials connecting to the same sql server are workng fine.
I have rule out bugs since we just upgraded the server to January 2024 version.
I have not ruled out the actual report (errors in formulas or calculations) and data issues (incorrect values) since the refresh now actualy updates the information on the report.
Tested connection to the data source (a SQL Server using a service account) from the PBI Report Server. An dalsto using Powershell and both were succesful.
The refresh runs at 11:20 Mon to Fri and before this time there are refreshes that run successfully.
From the Power Bi report Server stand point is there anythign else I can check?
could this be an issue with th db ReportServer and ReportServertemp database?
Thank you in adv
