Refresh failed: power bi has failed to refresh

[prvn]

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.

[v-janeyg-msft]

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.

[DavisBI]

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!