Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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. 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
Hi @Sowmiya ,
Based on my research, You can follow this documents to disable backgroud refresh to improve performance in Power Query Editor,
Then you can follow this documents to reduce your data model size by removing unnessary data.
Please refer to the similar post:
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |