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 !?
i cant make aggregate tables as the data needed was of profile responses with question and answers kind of data.
Please can some one help with this.