Power Query in Excel with Python
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?
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 pdimport glob, os# more Python statement here”)in Source Will this also come to Power Query in Excel? Read More