Forum Discussion
Speed up import possible ?
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
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
2 Replies
- v-lili6-msftCommunity Support
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- poPost Prodigy
Thansk for update