Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Our customer has an issue with a dataset scheduled refresh. Problem started on 15. March (14. March update went normally, nothing that I know of has changed in the customer environment or in the report itself.
When the dataset tries to refresh, after just about 1 - 1.5 minutes it always fails with this kind of error:
--
There was an error when processing the data in the dataset.
Data source error: {"error":{"code":"DM_GWPipeline_Gateway_TimeoutError","pbi.error":{"code":"DM_GWPipeline_Gateway_TimeoutError","parameters":{},"details":[],"exceptionCulprit":1}}} Table: NNNNNNNNNNNN.
Cluster URI: WABI-WEST-EUROPE-B-PRIMARY-redirect.analysis.windows.net
Activity ID: 08d5fa8e-5dd5-45ed-a51a-6d2b2362717c
Request ID: 191471c1-13ce-4010-98d3-8d9a45b44046
Time: 2023-03-27 10:33:52Z
--
The table name in the message seems to change between errors, so the issue doesn't seem to relate a specific dataset table. The error also occurres in manual refresh (on demand), but only sometimes (I haven't figured out any pattern).
Report is using a On-Premise Gateway (standard mode) to refresh data from an on-premise SQL Server. The Gateway has been updated to it's latest version (3000.166.8) and restarted. The timeout setting in the report has now been set to 120, but it didn't have any effect.
The Dataset is quite large, about 700Mb and it's not using incremental refresh. Despite the fact that dataset is large and supposed to be a bit slow to refresh, I think it's weird that the timeout happens so fast (under 2 minutes).
Gateway logs don't seem to tell anything. Comparing the logs from the 14. March (when everything was still ok) to later days show that when the refresh fails, nothing seem to prevent the refresh from happening, it just stops doing anything.
The lines in the logs seem very similiar (between successful and failed refresh), but after about 80 lines of doing things, the Gateway just stops and then reports the "Pool cleaner connections removed: 0, count: 0, buckets: 0" line continously, like when idle. No errors or other unusual things are reported to the logs. QueryStartReport or QueryExecutionReport -logs don't have anything about the failed refreshes, like there wasn't any queries to execute at all.
The server (where the Gateway has been installed) is acting normally and doesn't seem to have issues with inadequate resources.
There have been same kinds of problems reported here lately, is this related to them? If so, do you have a guess, when the issue might be resolved?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Nameless_LW
Is the workspace where the dataset is located shared capacity or Premium capacity ?
Best Regards,
Community Support Team _ Ailsa Tao