Forum Discussion
Solved
Import CSV Data into PowerQuery without Reliance on FIle therafter
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...
"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.
"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.
- I got it! Just import the data into a table then query from that table as it lives in the Excel workbook. Makes sense. Thanks Sergei!
shocko , glad it helped
