Forum Discussion
Solved
Why Power Query change my Source step name and how do I change it back to Source?
Hello everybody,
I only renamed my query, but for some reason PQ change the name of the Source step to match the name of the query, and I can not get it back to Source.
There is nothing in the M code that would suggest a Source name change.
#table( type table [Data=record, Title = text], {
{[First="Bill", Last="Jelen"], "First"},
{[First = "Miguel", Last= "Escobar", Country ="Panama"],
"Second"},
{[First = "Ken", Last= "Puls", Country ="Canada",
#"Tall?" = true], "Third"}
} )How can I change the Source step back to Source and
How can prevent PQ from changing the Source step in the future?
Thank you.
Hi BenBlackswan
In order to control the step name shown in Applied Steps, you would have to use a let/in statement.
In this case you could write:
let Source = #table( type table [Data = record, Title = text], { {[First = "Bill", Last = "Jelen"], "First"}, {[First = "Miguel", Last = "Escobar", Country = "Panama"], "Second"}, {[First = "Ken", Last = "Puls", Country = "Canada", #"Tall?" = true], "Third"} } ) in SourceRegards
2 Replies
Hi BenBlackswan
In order to control the step name shown in Applied Steps, you would have to use a let/in statement.
In this case you could write:
let Source = #table( type table [Data = record, Title = text], { {[First = "Bill", Last = "Jelen"], "First"}, {[First = "Miguel", Last = "Escobar", Country = "Panama"], "Second"}, {[First = "Ken", Last = "Puls", Country = "Canada", #"Tall?" = true], "Third"} } ) in SourceRegards