search

microsoft / python-in-excel

Python in Microsoft Excel
MIT License
532 stars 36 forks source link

Add Python.Execute() function to Excel #33

Open cbaragao opened 1 year ago

cbaragao commented 1 year ago

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 commented 1 year ago

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 commented 1 year ago

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 commented 1 year ago

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.