Forum Discussion
Dealing with Large Datasets
Power BI Community, How do you deal with large datasets? Do you always utilize a live connection to a SSAS cube or import the data? I am at my wits end. I am attempting to figure out the best...
Anonymous tested and yes I can confirm the usage of list inside column parameter
Csv.Document(File.Contents("C:\Users\X\Desktop\csv.csv"),[Delimiter=",", Columns={"Column1","Column3"}, Encoding=65001, QuoteStyle=QuoteStyle.None])
When I tested that code, it renamed columns 1 and 2 as "Column1" and "Column3", respectively, rather than pulling columns 1 and 3. As you mentioned in your first response, it seems to pull left to right rather than being able to select defined columns.