Refresh failed: power bi has failed to refresh

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!