Showing results for 
Search instead for 
Did you mean: 

Add ability to load dynamic content in Power Query

It would great if "Transform data using Power Query" could accept as an input dynamic content output from a previous step, i.e. turn a value from earlier in a flow into a variable we could inject in the M code / SQL query.

Status: New
Advocate IV

I support his idea.

even knowing we can filter afterwards, it would simplify Some flows using one single transformer power query We the provided parameter, instead of creating one for scenario.

another big advantage, so much more Easy  to filter on transformer Power query Instead filtering filter array.


Advocate IV

I believe Power Automate and Power Query are two Microsoft products with great (proven) possibilities. It still is holding back a whole lot of potential, because they don't truly integrate as one would expect. Power Automate is based on dynamic content. Now however Microsoft implemented a one-way dynamic content: from Power Automate to the downside flow. Why not incoming dynamic content to the Power Query step?

Furthermore: why is the Power Query connector limited to only SQL server??? Power Apps, Power BI, all support Power Query online with all the data sources one would except from Power Query. 

Advocate I

I support this idea 100%, I see it as very necessary since this way one would avoid filtering later using "Filter Array" of "Data Operation", although it seems very strange to me that this had not been contemplated before and much more before the development of the action of "transform data using Power Query", I believe that agile development methodologies ignore the obvious and prefer to take what was thought at the time; but in truth, this feature is urgently needed and it is much more optimal to send dynamic content before executing the aforementioned action.