Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
frithjof_v
Community Champion
Community Champion

Rename source and navigation step

Hi,

 

I think it's a good practice to rename the applied steps in Power Query, so that the step names can be a useful part of the "documentation" and explanation of what's going on inside my M queries.

 

This includes the Source and Navigation steps in my M queries. I would like to give these steps also more meaningful names. 

E.g. rename the Source step to contain the name of the source system, and rename the Navigation step to contain the name of the source table. 

In the case of a referenced query, I'd like to rename the Source step to contain the name of the referenced query. So it's easy to get a quick overview of what's going on in Applied steps and how my queries are connected.

 

Unlike other steps, it's impossible to rename the Source and Navigation steps directly in the UI. The options to rename these steps are greyed out in the UI.

So I will need to rename these steps inside the Advanced editor.

 

I'm wondering if there is some risk attached to renaming these steps in Advanced editor?

(I.e. is there a special reason why the option to rename these steps is greyed out in the UI, and thus we shouldn't do that in Advanced editor also?) Is there anything "magical" about these step names (Source and Navigation)?

 

As far as I know, each step in an M query is a variable, and it should not matter - with regards to the functionality of our M queries - which names we choose for the variables. I understand that Source and Navigation are the default names which gets created for these steps when using a connector to get data. However I think I can rename these steps and still have exactly the same functionality. At least that is my experience.

 

Anyone knows some more about this?

 

Thanks in advance!

1 ACCEPTED SOLUTION
PwerQueryKees
Impactful Individual
Impactful Individual

I regularly rename the source step in advanced editor without problems. The navigation steps is not really one step normally. I just leave it alone normally...

View solution in original post

1 REPLY 1
PwerQueryKees
Impactful Individual
Impactful Individual

I regularly rename the source step in advanced editor without problems. The navigation steps is not really one step normally. I just leave it alone normally...

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors