Power Query - editing tables

[canefan17]

I used Power Query to import file from folder. I then “close and load data” and a table appears.

My question is this...
Can I make changes to this table (deleting rows, etc) without having to go through Power Query editor?

So far, whenever I alter the table in anyway, it will revert back to original data when I hit refresh.

Has anyone else come access this?

I’m building these files so that our analysts can go in and make changes to the tables/data (without having to use Query editor).

 

[sandy666]

you can change source Tables or Query Table in PQ Editor but you can't "change" the result of Query Table loaded into the sheet

any changes required PowerQuery

 

[canefan17]

you can change source Tables or Query Table in PQ Editor but you can't "change" the result of Query Table loaded into the sheet

any changes required PowerQuery

That’s just crazy to me. Most analysts have to do things to do the data after it’s loaded. And doing it in Power Query (e.g. deleting specific rows) isn’t near efficient as editing the table itself.

 

[sandy666]

so if the result (Query Table loaded to the sheet) is the end result you can from context menu select Table - Convert to Range then you can do what you want

 

[canefan17]

so if the result (Query Table loaded to the sheet) is the end result you can from context menu select Table - Convert to Range then you can do what you want

Ok - I’ll play around with that.
Thanks

 

[sandy666]

yo are welcome

if you learn more about PQ will be easier to manage data

• What is PowerQuery
• Getting started with PQ
• PowerQuery Help
• PowerQuery M reference