Oct 22 2021 10:18 AM
I'm a very basic user of excel but trying to become more sophisticated in what I do with it. Often these days I find myself needing to import CSV data from a .csv text file. I generally use the Data -> New Query From -> option to create a power query and then I can do other cool stuff. One thing that I find frustrating though is this method seems to link the data set to the CSV file. I often delete the CSV file after importing it. Later, if I need to modify the DAC query etc. it's tells me I cant for certain operations as the Data source cannot be found. Is there a method to import the CSV data into excel directly without any reliance on the underlying file?
Oct 22 2021 12:18 PM
Solution"method to import" assumes you have some data source from which to import. You only may duplicate this data source moving from external file into Excel sheet. Power Query csv file, load into Excel sheet as table and remove the query. Table becomes not refreshable. Power Query this table, do any transformations you need, land result into another table.
Nov 15 2021 04:13 PM
Nov 16 2021 12:27 AM
@shocko , glad it helped
Oct 22 2021 12:18 PM
Solution"method to import" assumes you have some data source from which to import. You only may duplicate this data source moving from external file into Excel sheet. Power Query csv file, load into Excel sheet as table and remove the query. Table becomes not refreshable. Power Query this table, do any transformations you need, land result into another table.