Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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
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