Forum Discussion
Improving Data Transfer Speed in ETL Process
Use CSV data sources wherever possible. (Dataflows are basically bunches of CSV files, too, so they are a good second best choice)
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
