Constant refresh failures after report server upgrade

[SamKrygsheld]

We recently updated to the June release of the report server, and now scheduled refreshes are failing constantly. Almost all of them fail with the message:

[0] 0: There is no data in the database for @CatalogItemId=[CatalogItemId];@ContentType=DataModel

 There is definitely data in the database, and querying from SSMS will load it every time. I've never had a refresh fail within PowerBI desktop either, only on the server. Manually refreshing sometimes causes it go through successfully, but sometimes that fails too.

[SamKrygsheld]

It seems the solution was "Delete the dashboard and re-upload the exact same file." Not great, but at least it's back up and running.

[KBO]

Hi @SamKrygsheld ,

I guess you mean may 2020? Do you connected to the new/updated Database? Take a look into the Report Server Configuration manager and check the database :).

Best, Kathrin 

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!

[Greg_Deckler]

@SamKrygsheld You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".