Forum Discussion

sara_sameer's avatar
sara_sameer
Frequent Visitor
1 year ago
Solved

Data Refresh Failed | Power BI Report Server

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? 

 

Power BI Report Server not refreshing.
Refresh

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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

    • sara_sameer's avatar
      sara_sameer
      Frequent Visitor
      1 year ago

      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,