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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
AliceW
Impactful Individual
Impactful Individual

In the Edit Query window, can I see what a certain step did?

Hi everyone,

 

I have the feeling the answer is 'no', but here it goes.

 

I have added certain steps into the query, but for the life of me I can't figure out which rows are being filtered in this second step in the image. The dataset is huge in both number of rows and columns, and visually there's no way I can figure it out. 

 

Capture.JPG

 

Thank you in advance, community!

 

Alice

1 ACCEPTED SOLUTION
Shivendra
Frequent Visitor

01 :  Go to "Edit Queries>> Home tab >> Advanced Editor" here you can see the "M Code" of that particular step. 

 

02:   In "Edit Queries">> View Tab enable "Formula Bar". This will show you "M Code" for that particular step

View solution in original post

2 REPLIES 2
Shivendra
Frequent Visitor

01 :  Go to "Edit Queries>> Home tab >> Advanced Editor" here you can see the "M Code" of that particular step. 

 

02:   In "Edit Queries">> View Tab enable "Formula Bar". This will show you "M Code" for that particular step

AliceW
Impactful Individual
Impactful Individual

Thanks, Shivendra! Your solution number 2 is especially useful!

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.