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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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