Hi
I deployed some pbix reports on PBIRS. I created scheduled refresh. My problem is that they sometimes fail and sometimes succeed. I am talking about the same pbix file. The same pbix file fails and succeed. That is why I think it is something about PBIRS. If it was about the pbix file, it wouldn't had refreshed at all.
Also, when I go to
Manage => Scheduled Refresh => Refresh Now
they successfully refresh, some from the first time, some from the second, third or fourth time
I mainly have 3 errors
1- Unable to combine data error.
Exact error syntax
ErrorCode 1055784932 Unable to combine data: xxx references other queries or steps, so it may not directly access a data source. Please rebuild this data combination
2- Deadlock victim
Exact syntax
ErrorCode 0 Transaction Process ID 71 was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction
3- Report Server Database Unavailable
Exact syntax (there are 2 actually)
3-1- ErrorCode 1056505856 COM error: Microsoft.BIServer.HostingEnvironment, ReportServerDatabaseUnavailableException
3-2- ErrorCode 1056505856 COM error: Microsoft.PowerBI.ReportServer.ASEngineManagedRoot, ReportServerDatabaseUnavailableException
So why does that happen ?
And is there a way to tell PBIRS to keep refreshing until it reaches a success, just like I do but somehow programmatically ?
Thanks
