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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
aminakov
Frequent Visitor

Please create a feature like query plan for Power Query

As far as I know, PQ creates some internal presentations for calculating M scripts, reshuffling M queries and making something like tunnels/pipelines to data source from a number of steps, which are described in M scripts.

 

E.g. internally 

s0 = #table..,
s1 = Table.AddColumn(s0,"2", each f(_)) ,
s2 = Table.RemoveColumns (s1,"1")

is the same as

s0 = #table.. ,
s1 = Table.TransformColumns(s0, {"1", each f(_)})

 Defenitely, it would be great to virtually see the resulting "tunnels", just like SQL programmers can see query plans of SQL queries.

It would help M developers in many ways:

1. They could really understand what M constructions are more effective that others. Even if you are an experienced M developer, you cannot imaging the whole tunnel for a query of 10 Queries of 10 - 50 steps in each.

2. They could really understand when they should stop keep visual representing of step result, and start to hard-code 10-ths folding of M functions in one step in PQ UI.

 

Now, from my experience, in case of complex ETL, the time, which you gain due to using functional language & rich concept & functionality of M, will be loosed on boring analysis of the possible variants of tunneling and trying different variants without clues what is really more effective or not.

1 ACCEPTED SOLUTION
Nolock
Resident Rockstar
Resident Rockstar

Great idea, please let the PBI team know about your idea via https://ideas.powerbi.com/forums/265200-power-bi-ideas.

View solution in original post

2 REPLIES 2
aminakov
Frequent Visitor

Nolock
Resident Rockstar
Resident Rockstar

Great idea, please let the PBI team know about your idea via https://ideas.powerbi.com/forums/265200-power-bi-ideas.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors
Top Kudoed Authors