Direct Query mode for Oracle Database

[powerbi-user]

Hi,

As part of requirement we need to connect to Oracle data base. the tables hold data more than 20 million rows. 

Using import method was making the desktop unresponsive and all the RAM of desktop being eaten up to eventually crash the power bi.

because of this we thought of going for Direct query mode. but again there is a limitation of 1 million rows on direct query mode.

i can understand that if you have a SSAS Tabular server with good memory, we can increase the limit in the file msmdsrv.ini configuration file.

But what is the best way for ORACLE database. is it not the purpose of direct query to be able to use in case of large amounts of data !?

Please can some one help with this.

Thanks

Raj

[v-xicai]

Hi @powerbi-user ,

You may use Incremental refresh for your ORACLE database, the Incremental refresh can significantly reduce data refresh duration, especially for large model tables. See more: Incremental refresh in Power BI Premium .

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[powerbi-user]

@v-xicai ,

Thanks for the response but we are not having Premium licence.

Other thing is lets say if we create a dataflow, in that case also when we try to connect from power bi desktop, it will try to import and load data in to desktop and that again wont help us.

Appreciate if you can give any other workaround.

Thanks

Raj