Hi all,
Since a few weeks we have some severe problems with a lot of reports on our ReportServer.
After a scheduled refresh, all of the visuals are broken and the reports say
"There is a problem with one or several columns: (Dataset): column-name.
Please try again later or contact the support."
(translated from german)
The error doesn't occur after every refresh, but of the ~40 reports which are updated daily, we have this issue with at least 1-2 reports every day.
When downloading the reports into Power BI Desktop, the report is loaded properly and a manual refresh is also working. After re-publishing the report to Power BI RS it works again for some days.
We already analyzed all of the available logs without being able to locate anything suspicious.
Most of the reports use the same underlying data sources which are in CSV or XLSX format and are located on an on-premise network share.
We are currently using Report Server version 1.3.6816.37243 (August 2018) and are on the road of updating to March 2019 version. However we haven't experienced this kind of problems before, although we didn't change anything infrastructural since the beginning of 2019.
Is there anyone who experienced something like that before and can give us a hint?
Thanks, Ilja
