PBRS Oct 2020 encounter errors in scheduled refresh

Hello @Petebro ,

I think i found the problem. In my hybrid models, I have 3 datasource

1. Xlsx files

2. SQL server

3. Some table create by entered data

I replace the entered data table with xlsx files, the refresh problem solved

Issue confirmed here as well.

Recreated by:

1. Added data source sql server table for import. Tested schedule in PBIRS -> successful refresh

2. Added small table by "Enter Data" (unrelated to table 1 from sql server). Tested schedule in PBIRS -> error

3. Tried a combo of SQL Server import source and excel file -> Works fine.

Issue seem to be related to tables generated from "Enter data". Refreshing in PBIRS encounters error, both in manual triggering of schedule and "on-clock" schduled runs. Error message returned is:

SessionID: 864f8ded-276d-4fb2-a5f5-8af41c243372
[0] -1056505856: COM error: System.Core, Sequence contains no elements.
[1] -1055784828: The database operation was cancelled because of an earlier failure.

This is a very critical issue that is quite hard to find. No upgrader for us unitl this is fixed... 😞

Crossing our fingers for a buggfix in a relase coming soon. 🙂