Loading Time in Power BI

Question

Hi Community,Please give your suggestion and tips to reduce the time to load data into Power BI Dataset.My Source Data is in CSV with large size nearly 15GB.&nbsp; On Loading the data from Edit Query to Dataset, it is taking a too long time approximately 4-5 hours. My RAM size is 8GB. How to increase my time efficiency.Thanks in advance,With Regards,Sowmiya

v-lid-msft · Answer

Hi&nbsp;Sowmiya&nbsp;,&nbsp;Based on my research, You can follow&nbsp;this documents to disable backgroud refresh to improve performance in Power Query Editor,&nbsp;Then you can follow this documents to reduce your data model size by removing unnessary data.&nbsp;Please refer to the similar post:https://community.powerbi.com/t5/Desktop/Poor-performance-in-data-refresh-using-multiple-large-CSV-files/td-p/128280https://community.powerbi.com/t5/Desktop/Can-I-speed-up-of-import-query-from-CSV-file-with-30-000-000/td-p/130046&nbsp;Best regards,Community Support Team _ Dong LiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Loading Time in Power BI

1 Reply

Related content

Impossible to Load: Token Time Out in Power Query

Power BI app - very slow loading time

Error loading Power BI report

Power BI Incremental Load HELP

power query editor slow loading