many smaller files or fewer and bigger files

[Anonymous]

Hi guys,

I'm trying here to reduce the updating time in power query.

What do you think it's faster to update all my sources?: many smaller files or fewer and bigger files?

Thank you all

Best regards

Pedro

[v-yulgu-msft]

Hi @Anonymous ,

For how to improve the performance of data refresh, please have a look at below blog which shows performance is influenced by the method of loading data.

Power BI, Caching, Parallelism And Power Query Refresh Performance

Best regards,

Yuliana Gu