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...
Thank you for extending your help to us. Currently we are acrrying out DB to DB data transfer. Any suggestions on how to improve the dta transfer speed from DB to DB??
Can you please explain a bit more?
Are you trying to refresh data from Oracle to Power BI? or you are trying to data refresh first from Oracle to SQL Server then to Power BI?
Is it necessary to import all the data (400GB) in Power BI? Since data refresh takes too much time you can try out direct query?
https://docs.microsoft.com/en-us/power-bi/connect-data/power-bi-data-sources
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery