Skip to main content
cancel
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.

Reply
prvn
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:
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.
2 REPLIES 2
v-janeyg-msft
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.

6.png

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

 

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!

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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