Is there a way to limit the number of lines loaded for a csv

[Bebs]

Hi,
I'm working in PowerBI with several big csv files including a 7Go csv File. It works, but for development, is there a command, an option, or something to add in :

= Csv.Document(File.Contents("E:\myfile.csv"),[Delimiter=",", Columns=10, Encoding=65001, QuoteStyle=QuoteStyle.None])
To limit the number of loaded lines (exemple : 10 000).

To develop the power Query part, I don't need to load the full data set. And with the full set of data, it takes forever to apply any modifications in Power Query

Thanks

[m_dekorte · Accepted solution]

Hi @Bebs,

There is no parameter to control the number of rows for Csv.Document BUT  you can use Keep Rows on the Home tab to limit the number of rows by keeping only the top, bottom or a range of rows as first transformation. Once development is done, you can delete that transformation step.

Alternatively, you can utilize R or Python to create a dataframe from the CSV but that is not native to M.

I hope this is helpful