Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
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.
@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
User | Count |
---|---|
92 | |
86 | |
67 | |
62 | |
58 |
User | Count |
---|---|
150 | |
113 | |
95 | |
80 | |
72 |