Sep 27 2024 01:25 PM
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?
Sep 30 2024 01:46 PM
Follow the Excel Blog re. new/upcoming features/functionalities (nobody on forums/communities is aware of/can speak on behalf of MSFT...)