Forum Discussion
Refresh issues via Gateway
Hi,
Various refreshes failing various times on various days, i.e. no consistency in refreshes. Some of these can take a while due to complex queries but they shouldnt be just dropping out. Gateway is confirmed as online, additional logging is enabled, no error logs shown on export of logs, connectivity tests all working ok and server has been up for 230 days so no down time recorded. Data source side has also been checked for completeness but dont think it is even getting that far on some of these errors, i.e. cant contact gateway 😞
today's issues are:
- BCC (6:11 AM) - Your data gateway is offline or couldn't be reached.
- NHS Digital (7:17 AM) - Before the data import for projects_suppliers_metrics finished, its data source timed out. Double-check whether that data source can process import queries, and if it can, try again.
- LBH (7:19 AM) - Before the data import for dates finished, its data source timed out. Double-check whether that data source can process import queries, and if it can, try again.
- LFC (7:44 AM) - Your data gateway is offline or couldn't be reached.
- DLG (7:44 AM) - Before the data import for dates finished, its data source timed out. Double-check whether that data source can process import queries, and if it can, try again.
- Tebodin (9:11 AM) - Your data gateway is offline or couldn't be reached. (Operational)
- 7. Tebodin (9:14 AM) - Your data gateway is offline or couldn't be reached. (Client Specific)
- 8. Devolksbank (9:14 AM) - Your data gateway is offline or couldn't be reached.
Running August 2019 version:
My questions are:
is there any further logging I can do to trap any issues?
what has additional logging done for me?
what are the mashup files, do they show me the individual report refresh requests?
Any other reasoning I am getting inconsistent refresh results?
5 Replies
- ScottDunkFrequent Visitor
adding this to show e do not use personal gateway:
- v-xicai
Community Support
Hi ScottDunk ,
For the dataset that contains on premise and cloud data source, 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.
You may resolve the issue via troubleshooting links:https://docs.microsoft.com/en-us/power-bi/refresh-troubleshooting-refresh-scenarios .
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.