Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
6 | |
4 | |
3 | |
2 |
User | Count |
---|---|
14 | |
10 | |
5 | |
3 | |
3 |