Forum Discussion
Inconsistent data Refresh in scheduled reports
Thank you ChrisMuthmann
Hi, AbbasRzaei8
I think you can check your refresh log file and take the time of execution of the log as the subject matter. This log file is located at: C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\RSPowerBI_*.log
This will give you an accurate picture of when your model initiated a refresh. The traditional workload of a report server is similar to that of a web application. The ability to load reports using imported data or DirectQuery, as well as the ability to perform scheduled refreshes, relies on an instance of Analysis Services hosted with the report server.
You can find information in the Refresh Question document to help you determine why:
Troubleshoot scheduled refresh in Power BI Report Server - Power BI | Microsoft Learn
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I cannot reproduce this misbehaviour. You have not posted your T-SQL for the ExecutionLog3. I would use something like that:
Select top 100 *
from ReportServerPBI.dbo.ExecutionLog3
where ItemAction = 'DataRefresh'
and ItemPath like '%yourdashboard%'
order by TimeStart desc;
Yes. This is the query that I used