cancel
Showing results for 
Search instead for 
Did you mean: 

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
Moderator

Hi @sudhirreddy

 

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...

 

Best Regards,
Qiuyun Yu 

 

Visitor

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