Forum Discussion

prvn's avatar
prvn
Frequent Visitor
5 years ago

Refresh failed: power bi has failed to refresh

I have some reports in Power BI report server most of them have scheduled refresh. Some have duplicate name. One of the report refresh is failing i'm unable to find which one. I have been receiving notification on the refresh failed for months now. When i click on learn more in the failure notification mail, it takes me to the Report server Datasets page but i could not find any issues there or the report that has the refresh failed. Below is the email i get.

 

{"error":{"code":"DM_GWPipeline_Gateway_TimeoutError","pbi.error":{"code":"DM_GWPipeline_Gateway_TimeoutError","parameters":{},"details":[],"exceptionCulprit":1}}} Table: DimSubProject.

 

Technical Information

Activity Id:
54f87ed4-5ee1-483e-8ff1-8a20af06179f

Request Id:
9618e140-6ff3-4692-ad89-9b904ba068f5

Cluster Name:
WABI-NORTH-EUROPE-D-PRIMARY-redirect.analysis.windows.net


Refresh Start Time:
January 3, 2021 18:30 UTC

Refresh End Time:
January 3, 2021 18:38 UTC

 

I have unchecked below option

Send refresh failure notifications to the dataset owner
Still i recieve emails.
scheduled refresh

2 Replies

  • DavisBI's avatar
    DavisBI
    Icon for Solution Specialist rankSolution Specialist
    5 years ago

    Hi, prvn ,

     

    Connect to your report server database in SSMS, 

    then try this query to find the report that failed to refresh:

     

    SELECT 
	[Name] as [ReportName]
	,[Username] as [Publisher]
	,[Path]
	,[LastStatus]
	,[LastRunTime]
	FROM [dbo].[Subscriptions] A0
	LEFT JOIN [dbo].[Catalog] A1 
	ON A0.Report_OID = A1.ItemID
	LEFT JOIN [dbo].[Users] A2
	ON A0.OwnerID = A2.UserID
	where [EventType] = 'DataModelRefresh'
	and [LastStatus] <> 'Completed Data Refresh'
	and [LastStatus] <> 'New Scheduled Refresh Plan'

     

    ([Path] shows the storage path of the report)

     

    Mark this answer as a solution if this helps, thanks!

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi, prvn 

     

    The error message you sent seems to be from PBI Service instead of report server, and you can use 'view lineage' to check information about the dateset like report name,date source.

    If it doesn’t solve your problem, please feel free to ask me.

     

    Best Regards

    Janey Guo

     

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