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
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,