ODBC: ERROR [HY001] Out of memory while reading tuples.;\nmemory allocation error???

[rdi_vinicius]

Hello friends.

I need help. I'm new to power bi online.

I have a report that I connect to a postgres database via the ODBC driver. I have configured an incremental refresh on this report.

On power bi desktop the update occurs normally.

Now in the online service I use the pro account and the automatic update does not work. Displays the following error:

Erro durante o processamento de dados no conjunto de dados.Ocultar detalhes
Erro de fonte de dados: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"ODBC: ERROR [HY001] Out of memory while reading tuples.;\nmemory allocation error???"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"Odbc"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":

I do not know what else to do. Any ideas to help me?

Thanks

[johnbasha33 · Accepted solution]

@rdi_vinicius 

The error message you're encountering indicates that there's a memory allocation issue while reading tuples from your PostgreSQL database through the ODBC driver. This can happen when the dataset being retrieved is too large to be processed within the available memory limits.

Here are some steps you can take to address this issue:

1. Optimize Query: Review the queries used to retrieve data from your PostgreSQL database and ensure they are optimized for performance. This may involve limiting the amount of data being retrieved, optimizing joins and filters, and avoiding unnecessary calculations.

2. Incremental Refresh: Since you've already configured incremental refresh in Power BI Desktop, ensure that it's set up correctly in the Power BI service as well. Double-check the settings for incremental refresh in the dataset settings in Power BI Online to ensure that it aligns with what you've configured in Power BI Desktop.

3. Data Source Permissions: Ensure that the user account or service principal used to access the PostgreSQL database has sufficient permissions to retrieve the required data. Sometimes, permission issues can cause errors during data retrieval.

4. Check Resource Limits: Review the resource limits and constraints in your Power BI environment, such as dataset size limits and memory allocation limits. If the dataset being retrieved exceeds these limits, you may encounter errors like the one you're seeing.

5. Check ODBC Driver Configuration: Ensure that the ODBC driver configuration is optimized for performance and that any necessary updates or patches are applied. Sometimes, outdated or misconfigured drivers can cause performance issues.

6. Review Data Model: Review the data model in your Power BI report and ensure that it's optimized for performance. This may involve simplifying relationships, reducing the number of tables and columns, and optimizing data types and formats.

7. Contact Support: If you're still unable to resolve the issue, consider reaching out to Microsoft Support or your organization's IT support for further assistance. They may be able to provide additional insights or escalate the issue for investigation.
   
   Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!