Power Query (Dataflows gen2) has a user friendly GUI to generate ETL code, and hand coding is occasionally required to handle tricky cases. In contrast, impelemting ETL in Python mostly involves hand writing code.
What is the future direction in MS Fabric in terms of Power Query vs Python? Is Power Query engine being improved so that Python will not be required? Or, is Python going to be the de-facto ETL language in Fabric?
Instead of investing in time and effort to master both of these languages, is it worthwhile to focus on one and master it?