cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Broken Reports after scheduled refresh

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

4 REPLIES 4
Highlighted
Frequent Visitor

Re: Broken Reports after scheduled refresh

Hi @IMett , i came around the same problems with my reports. 

 

Did you find a soletion exept for deleting the re-uploading the reports ? 

 

Regards, Thomas

Highlighted
Frequent Visitor

Re: Broken Reports after scheduled refresh

Hi @ThomasLienard , indeed after updating to the Mai 2019 version (which we did in September 2019), we didn't observe this issue any more.

Highlighted
Frequent Visitor

Re: Broken Reports after scheduled refresh

For me, it started with the January 2020 version. 

 

I am continuing my investigation.

Highlighted
Frequent Visitor

Re: Broken Reports after scheduled refresh

Sounds like we shouldn't update to the January 2020 version then...

 

Let me know if you find out something.

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors