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...
Need Help
  • v-csrikanth's avatar
    v-csrikanth
    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.

     

v-csrikanth's avatar
v-csrikanth
Community Support
1 year ago

Hi fatou 

You can follow these steps to verify gateway configuration-

Go to Power BI Service > Settings > Manage Gateways.
Make sure that the ODBC data source is correctly configured and pointing to the correct ODBC connection on the gateway machine.
If your ODBC data source requires a specific driver version, confirm that it's installed on the gateway machine.

Sometimes, in Power BI Service there can be a mismatch in the authentication method.
So, try re-entering them in the Power BI Service to ensure there’s no issue with authentication.

Go to Power BI Service > Settings > Data Source Credential.

By following these above steps, you will be able to refresh in Power BI service.

 

Hope this helps!

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.