Speed up import possible ?

[po]

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

[v-lili6-msft · Accepted 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

[po]

Thansk for update