Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Frequent Visitor

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:

Request Id:

Cluster Name:

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.
Community Support
Community Support

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.

Solution Specialist
Solution Specialist

Hi, @prvn ,


Connect to your report server database in SSMS, 

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


	[Name] as [ReportName]
	,[Username] as [Publisher]
	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!

Helpful resources

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.


Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.