topic Re: BUG - Scheduled Refresh failing in October 2020 in Report Server

BUG - Scheduled Refresh failing in October 2020

Anonymous — Wed, 11 Nov 2020 06:25:20 GMT

Existing reports modified and saved in October 2020 version of the RS is failing. This is happening after upgrading from May 2020 version. This is a huge issue and need fixing asap. This has been highlighted in other posts as well.

Using PBI RS Desktop Oct 2020 version too. Here's the error. Trunated confidential information.

SessionID: 3359cf9d-11f7-4cc3-a850-bc8ca8da2b3b
[0] -1056505856: COM error: System.Core, Sequence contains no elements.
[1] -1055784828: The database operation was cancelled because of an earlier failure.
[2] -1056505856: COM error: Microsoft.PowerBI.ReportServer.ASEngineManagedRoot, Datasource {"protocol":"tds","address":{"server":"[truncated]","database":"[truncated]"},"authentication":null,"query":"\n[truncated]"} is not found..

Re: BUG - Scheduled Refresh failing in October 2020

Anonymous — Wed, 11 Nov 2020 12:17:05 GMT

Hello,

This has been mentioned in a few other threads already, it seems to affect many users (myself included). One of the workaround I have seen is to restore a backup of your pbix from before the upgrade, either uncheck the new metadata preview feature or downgrade PBI Desktop to May 2020 and resave the file. But of course that’s not an option for everyone.

Another workaround is the remove all “Enter Data” tables (for example by converting them to Excel sources). That seems to work for some people but unfortunately for me it just changed the System.Core error to something else. These are the only 2 workarounds I’ve found so far, otherwise we are still waiting on Microsoft.

Best Regards,

Re: BUG - Scheduled Refresh failing in October 2020

SajjadMousavi — Fri, 13 Nov 2020 13:46:13 GMT

It's true. We have the same problem in our company and this issue waste our time and resources. we've just downgraded it to May edition and waited for a patch from the Power BI team.

Re: BUG - Scheduled Refresh failing in October 2020

Arman_Rzn — Sun, 15 Nov 2020 07:21:19 GMT

I faced the same problem as well, in two different report servers.
the same situation happened in Report Server Refresh when the Jan-2020 version first released.
I like to see the downgrade option as my last try. Is there any other way to solve this issue?

Re: BUG - Scheduled Refresh failing in October 2020

AdEzone — Sun, 15 Nov 2020 18:26:39 GMT

Hi,

You don´t need to downgrade the server, it is Ok.

You need to find the backup .pbix it is automatically done before changing the Metadata Model (which is the issue - the model transformation). You can find this backup in:

c:\users\username\AppData\Local\Microsoft\Power BI Desktop SSRS\TempSaves\Backups

1 of those files with fancy names that include the version it was created-saved must be the models have stopped refreshing.

You need to downgrade the Desktop to May 2020 or, if you want to continue with Oct2020 will need to disable "Allow saving the datamodel in the Enhanced Dataset Model" in Options - Preliminary options. (or something similar, I have the spanish language desktop), so the transformation doesn´t happen before publising in the Server.

I hope you can solve the issue with this...

Re: BUG - Scheduled Refresh failing in October 2020

Anonymous — Tue, 17 Nov 2020 08:21:14 GMT

Hi AdEzone

Thanks for the reply. Unfortunately don't have the back up pbix files.

Waiting for MS to fix this!

Re: BUG - Scheduled Refresh failing in October 2020

AdEzone — Tue, 17 Nov 2020 12:44:22 GMT

Hi,

They should be in the path I posted.

c:\users\username\AppData\Local\Microsoft\Power BI Desktop SSRS\TempSaves\Backups

Those are automatic backups... but they have stupid names... You need to open them manually to see the content.

Regards

Re: BUG - Scheduled Refresh failing in October 2020

Anonymous — Wed, 18 Nov 2020 16:27:16 GMT

AdEzone , unfortunately don't have any backup files saved.

Anyway, would want a permanent fix from Microsoft for this. Hope they release a patch or an early version this month.

Re: BUG - Scheduled Refresh failing in October 2020

Petebro — Thu, 19 Nov 2020 16:57:34 GMT

Hi Anonymous

I'm happy to report that the "enter data" issues blocking refresh has been patched in a new update for Power BI Report Server October 2020. Find more information here:

https://community.powerbi.com/t5/Report-Server/Power-BI-Report-Server-October-2020-update-has-been-released/m-p/1503433#M16773

Re: BUG - Scheduled Refresh failing in October 2020

ianmanton — Thu, 26 Nov 2020 16:12:05 GMT

Hi Petebro this doesn't appear to be fixed (and disabling preview metadata function didn't hep either) - we have just moved to this (later) 18th nov release from the may 2020 release - and are encountering the "fixed" issue of scheduled report refreshes complaining of missing credentials (they aren't). Is there any update on steps to resolve please?

Re: BUG - Scheduled Refresh failing in October 2020

jamiestevens28 — Fri, 27 Nov 2020 14:15:21 GMT

We too are looking for a solution. We are in the process of ensuring our developers have unchecked the preview feature in the Oct 2020 PowerBI Desktop for RS. That being said, we now have several reports on our production server where going back to a backup from a pre-Oct 2020 pbix file is not an option.

Would you have a timeline as to when there will be a fix?

Re: BUG - Scheduled Refresh failing in October 2020

jamiestevens28 — Sat, 28 Nov 2020 23:06:36 GMT

We too are looking for a solution. We are in the process of ensuring our developers have unchecked the preview feature in the Oct 2020 PowerBI Desktop for RS. That being said, we now have several PowerBI reports that are not refreshing, which would take much effort to recreate.

Re: BUG - Scheduled Refresh failing in October 2020

jimv2000 — Fri, 04 Dec 2020 15:46:03 GMT

I am unhappy to report that the 11/18 build does NOT fix this issue.

Re: BUG - Scheduled Refresh failing in October 2020

Anonymous — Tue, 08 Dec 2020 12:10:00 GMT

Wonder if you had a resolution here? Same issue is persisting with us as well.

Re: BUG - Scheduled Refresh failing in October 2020

pabeader — Tue, 08 Dec 2020 14:36:07 GMT

Not sure if this will help anybody else but...

I finally got all but one of my reports to consistantly refresh. Both scheduled and manual

What I found was that I had unjoined, scale-out servers listed in the group. These servers were only used for testing and no longer had Report Server running on them. I had to start report server back up. Join the 'test' server. Unjoin it. Then shutdown the Report Server on that machine. Once I went through all of the unjoined servers, the refreshes started working correctly.

Apparently, even though they were not longer part of the scale-out, Power BI was trying to use them to render the reports. Now that they are no longer listed in the 'main' report server, I have no issues with them refreshing.

I am still having trouble with my one WEB based report, but I can manually refresh that one so that's okay for now.

Re: BUG - Scheduled Refresh failing in October 2020

jimv2000 — Tue, 08 Dec 2020 20:29:34 GMT

Yes, I figure out a fix...basically was a re-install while saving the config files. I'm assuming something in the updater isn't working right. Specific details in this comment.

Re: BUG - Scheduled Refresh failing in October 2020

pabeader — Tue, 08 Dec 2020 20:31:52 GMT

Wow. So many different answers to this issue. Somebody needs to get a list of them all and put it in one place.