topic Re: Data Refresh Failed | Power BI Report Server in Report Server

Data Refresh Failed | Power BI Report Server

sara_sameer — Thu, 19 Dec 2024 11:47:13 GMT

Hello!

I have been facing refresh issues in power bi report server, the refresh schedule is failing due to this error

Any ideas how to fix this?

Re: Data Refresh Failed | Power BI Report Server

Anonymous — Fri, 20 Dec 2024 02:52:26 GMT

Hi, sara_sameer

You can refer to the solutions for the following cases, They're experiencing the same problems as you::

Solved: There is no data in the database for @catalogitemi... - Microsoft Fabric Community

Solved: Scheduled Refresh error "There is no data in the d... - Microsoft Fabric Community

Blogs related to this issue:

“There is no data in the database for @catalogitemid” in Power BI Report Server – SQL Ryan

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Data Refresh Failed | Power BI Report Server

Anonymous — Mon, 23 Dec 2024 05:41:45 GMT

Hi, sara_sameer

I wish you all the best. Previously we have provided a solution to help you solve the problem. Since we haven't heard back from you yet, I'd like to confirm if you've successfully resolved this issue or if you need further help?
If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.

Best Regards

Jianpeng Li

Re: Data Refresh Failed | Power BI Report Server

sara_sameer — Mon, 23 Dec 2024 06:37:13 GMT

Hello Anonymous,

Sorry for not being able to reply earlier.

I tried the solution you provided with the one if the links providing:

USE [PBIReportServer]
 GO
 ALTER PROCEDURE [dbo].[GetCatalogExtendedContentData]
     @CatalogItemID UNIQUEIDENTIFIER,
     @ContentType VARCHAR(50)
 AS
 BEGIN
     SELECT
         DATALENGTH([Content]) AS ContentLength,
         [Content]
     FROM
         [CatalogItemExtendedContent] WITH (READPAST) -- Reverting this back to May 2020 code. Commented line below is original in January 2021 version.
 --        [CatalogItemExtendedContent] WITH (NOWAIT) -- DevNote: Using NOWAIT here because for large models the row might be locked for long durations. Fail fast and let the client retry.
     WHERE
         [ItemID] = @CatalogItemID AND ContentType = @ContentType
 END
 GO

And it worked! havent faced any problems till now. Thank you for your help.

Regards,