Forum Discussion
Intermittent refresh failure - data source timed out - enterprise gateway
Hi Anonymous ,
There are several points you may considerate:
1.Ensure that you've added one or more data sources of your dataset to the gateway, as described in Add a data source.
2.Verify that you have the correct username and password. Also, verify that those credentials can successfully connect to the data source. Make sure the account that's being used matches the authentication method.
3.Your data source credential may expire, so try to update the credential and republish the report. In Power BI, go to refresh settings for the dataset. In Manage Data Sources, select Edit credentials to update the credentials for the data source.
4.If your dataset not only contains cloud data source but also the on premise data source, then it needs to use the gateway and configure schedule refresh, see more: :On-premises data gateway , Configure scheduled refresh .
Note that you also need to select Allow user's cloud data sources to refresh through this gateway cluster option Under Gateway Cluster Settings. See: Merge or append on-premises and cloud data sources.
5.Please make sure the gateway is online, and try to upgrade the gateway to latest version.
You may resolve the issue via the troubleshooting link :https://docs.microsoft.com/en-us/power-bi/refresh-troubleshooting-refresh-scenarios .
If you still have this issue for Power BI, you'd better create a support ticket in Power BI Support , Scroll down and click "CREATE SUPPORT TICKET", to get further help.
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I've been personally suffering what is described here:
We are going to attempt a trial of the supplied solution soon. Perhaps the testing and resolution described here might be useful to you as well?
- Anonymous6 years agoNot applicable
ross TY, very interesting.