Error with ODBC connection

Hi Fern_21 ,

Likely causes:

Long-running query: Large table or complex query causes the ODBC driver/Oracle to time out.
Default timeout settings: Both the ODBC data source and Power BI have timeouts that may be too low for the initial load.
Memory/size limits: Power BI Desktop may struggle with very large result sets; loading all 900k rows at once can blow memory.
Network/infrastructure timeout: If you’re connecting to a remote Oracle instance, network latency can trigger timeouts.
Inefficient query: Selecting all columns or using functions in Oracle can slow things down.

Steps you can try to fix:

Load only needed data
Break the load into smaller chunks,
Use filtering (WHERE clause) to load a subset (e.g., by date ranges or partitions).
If you need all data later, load in stages and append or use incremental refresh.

Please mark this post as solution if it helps you. Appreciate Kudos.