Issue with Refresh on Power BI Service using ODBC Elasticsearch

Hi fatou 

Thank you for being part of the Microsoft Fabric Community.
Please do follow the below steps to resolve the issue.

1. Create a minimal test with 1 table and try refreshing it in the service — confirms if it's model-related or gateway-related.. pbix
2. In Power Query, check if steps support query folding ( is enabled). Lack of folding can cause service refresh issues. View Native Query
   Enable gateway diagnostic logging and inspect logs at:
   C:\Users\<gateway-user>\AppData\Local\Microsoft\On-premises data gateway\GatewayDiagnosticLogs
3. Monitor gateway server’s RAM/CPU during refresh — resource limits can silently fail large refreshes.
4. Confirm DSN name and ODBC driver version match exactly between your desktop and the gateway server.
5. Re-enter credentials in Power BI Service under Data Source Settings. Set privacy levels in Desktop to “Ignore” and republish.
6. Use scheduled refresh instead of manual refresh — service sometimes mishandles manual triggers.
7. Simplify Power Query steps to avoid memory-intensive transforms. Push filters/joins to the source query.
8. If your source supports native connectors (e.g., PostgreSQL, SQL Server), use those instead of ODBC.

If the above information helps you, please give us a Kudos and marked the Accept as a solution.
Best Regards,
Community Support Team _ C Srikanth.