Forum Discussion

fatou's avatar
fatou
New Member
1 year ago
Solved

Issue with Refresh on Power BI Service using ODBC Elasticsearch

Bonjour,   Je rencontre un problème d'actualisation des données sur le service Power BI avec une source de données ODBC. Mon rapport fonctionne parfaitement sur Power BI Desktop et s'actualise sans...
  • v-csrikanth's avatar
    1 year ago

    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.