Forum Discussion
Improving Data Transfer Speed in ETL Process
We are using POWERBI in our organization. WE are having data around 400GB in our server. The issue is that it will take around a day to refresh all the dashboards which will be used to followup and m...
To improve the performance of importing large dataset from Oracle Database to Power BI, the key is adjusting “FetchSize” parameter in the connection string. Unfortunately there is no way to do that in the native Oracle connector in Power BI.
Luckily, you can adjust the connection string in OleDb connector. In my case I got 5 times performance improvement just by setting “FetchSize” to 5000.
Check the link below.