Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Data loading Time Taken

Hi all,

 

I am facing one issue, I am trying to load the table from Oracle database( ex: RA_Terms_tl (42,000 rows) it has taken almost 2hrs above ).

 

Can anyone please suggest for this issue?

 

 

 

Status: New
Comments
v-qiuyu-msft
Community Support

Hi @Anonymous, 

 

Did you write a query when getting data from the Oracle in Power BI desktop or just select a table in Navigator window then choose Load? 

 

When retrieving data from Oracle database, please ensure only useful data is retrieved. You can also use Oracle tool which has the same function of SQL profiler to check what happens with this session, see: https://stackoverflow.com/questions/148648/oracle-is-there-a-tool-to-trace-queries-like-profiler-for-sql-server

 

Best Regards,
Qiuyun Yu 

 

Anonymous
Not applicable

Hi Qiuyun Yu,

 

Thanks for your valuable suggestion.

Just select a table from Oracle database in the Navigator window.

Not written in any query ( direct query option)

 

Regards

Sudhir