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?
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
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)