Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Gateway Timeouts

Hello,    I have noticed a number of timeouts the past few weeks.  Does not always happen and usually happens when the refresh is scheduled.  If I do it manually we dont seem to have any issues.  A...
Need Help
v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Anonymous,

Do you use personal gateway or on-premise gateway? Please update your gateway to latest version first. 

If you use on-premise gateway, you can modify two configuration files to determine the duration of a query. Within the Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config file, change the EmitQueryTraces value from False to True. This file is located, by default, at C:\Program Files\On-premises data gateway. Enabling EmitQueryTraces will begin to log queries that are sent from the gateway to a data source.

For another, within the Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.dll.config file, change the TraceVerbosity value from 4 to 5. This file is located, by default, at C:\Program Files\On-premises data gateway. Changing this setting will begin to log verbose entries to the gateway log. More details, please see the "Reviewing slow performing queries" part in this blog.

Best Regards,
Angelia