Power Query in Excel with Python

Copper Contributor

Let me first say that I really enjoy Python in Excel and getting data into Excel with Queries work well, so congrats to all involved in improving Excel so much.

 

I am triggered to ask a question from what was released in Power BI Desktop some time ago:  The ability to embed Python inside queries, just like you can do for SQL.  Excel queries have been able to the SQL version for a long time.  Is there plans to expand to Python as well?  As example in PBI I can do the following:

 

let
    Source = Python.Execute

("import pandas as pd
import glob, os

# more Python statement here
")
in
   Source

 

Will this also come to Power Query in Excel?

1 Reply

@hennievn 

 

Follow the Excel Blog re. new/upcoming features/functionalities (nobody on forums/communities is aware of/can speak on behalf of MSFT...)