Cannot Record Actions when trying transform a regular table with PowerQuery

[fapb48]

Hi,

I have this report that i have to manipulate each week and i was trying to record the actions so i don't have to do the same laborious process every week.

One part of the manipulation involves in transforming the table with power query so i can remove the format type of the whole column and insert text type format on that same column instead.

But when i try to transform the data it says that those actions cannot be recorded..

Is this a normal behaviour? Cannot record PowerQuery actions?

Thank you

 

[GlennUK]

Once you have the Power Query set up, surely you just paste new data in, and re-run the query?