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,
Sometimes we need to import fairly large datasets into power bi and can take a while.
Currently don't have access to premium thus cannot use incremental refresh.
Is there an option e.g to increase the bulk size when it imports data. to speed this up?
Have seen some other tools where can increase array fetch size to collect more rows with each fetch.
and wondered if power bi has anything similar.
Thanks
Solved! Go to Solution.
hi, @po
Incremental refresh is only supported for power bi premium for now. And there is no similar way like it.
For your requirement, The best way is optimize your model:
remove unnecessary tables or columns, reduce unnecessary steps, etc.
https://docs.microsoft.com/en-us/power-bi/power-bi-reports-performance
https://community.powerbi.com/t5/Desktop/Importing-and-applying-data-changes-too-long/td-p/396803
https://www.thebiccountant.com/2016/11/08/speed-powerbi-power-query-design-process/
Best Regards,
Lin
hi, @po
Incremental refresh is only supported for power bi premium for now. And there is no similar way like it.
For your requirement, The best way is optimize your model:
remove unnecessary tables or columns, reduce unnecessary steps, etc.
https://docs.microsoft.com/en-us/power-bi/power-bi-reports-performance
https://community.powerbi.com/t5/Desktop/Importing-and-applying-data-changes-too-long/td-p/396803
https://www.thebiccountant.com/2016/11/08/speed-powerbi-power-query-design-process/
Best Regards,
Lin
Thansk for update
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |