Add Python.Execute() function to Excel

[cbaragao]

I would love to see Python.Execute() in Power Query for Excel. It would be a great way extend transformation and data cleaning capabilities in Power Query for Excel.

[keyur32]

Thanks for this request. To help me understand, can you outline what you're looking for with the Python.Execute() method? Are you asking if you can run a python formula directly as part of a pq transformation?

[ncalm]

I guess bring parity between Power Query in PBI and Power Query in Excel.
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-python-in-query-editor

[cbaragao]

Yeah, basically to be able to call Python from PowerQuery in Excel like you can with Power BI. Power Query in Power BI has the Python.Execute() function, Power Query in Excel does not.