Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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