Why Power Query change my Source step name and how do I change it back to Source?

[BenBlackswan]

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.

[OwenAuger · Accepted solution]

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
  Source

Regards

[Anonymous · Accepted solution]

There is no source, its just a table expression.  Just because it's your first applied step doesn't mean that it's the source or is a source even.

--Nate

[OwenAuger · Accepted solution]

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
  Source

Regards