Power Query - csv OR table in xlsm

[johnny51981]

General Question.

What is the better option to be using as a data source, a csv file OR a table in an xlsm file?

Is there any refresh speed difference by using one over the other?

Thank you in advance!

 

[alansidman]

I don't know that there is any significant difference if the files are of the same approximate size.

 

[GraH]

Csv loads faster then any xlsx format.
Google it, there are articles about the differences in performance.