You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
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?
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.
Activity
keyur32 commentedon Sep 20, 2023
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 commentedon Sep 20, 2023
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 commentedon Sep 21, 2023
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.
rootsmusic commentedon Dec 2, 2025
Keyur Patel (@keyur32) Since you have Python in Excel, why isn't Python script supported in Excel's Power Query?