Microsoft Fabric Notebooks currently support languages like SQL, Python, and Spark, which are excellent for data engineering and analytics workflows. However, many Power BI users and data professionals rely heavily on M (Power Query) for data shaping, cleansing, and transformation tasks.
Adding M language support to Fabric Notebooks would:
- Bridge the gap between Power BI and Fabric Notebooks, allowing users to reuse and test Power Query logic in a more flexible environment.
- Accelerate data prep workflows by enabling users to prototype and validate M scripts outside of Dataflows.
- Enhance collaboration between business analysts and data engineers by providing a shared space to work with M code.
- Support migration and modernization efforts by allowing legacy Power Query scripts to be integrated into Fabric pipelines and notebooks.
This feature would be especially valuable for organizations transitioning from Power BI-centric workflows to Fabric-based architectures, ensuring continuity and reducing friction and, It would simply be another cool option!
on:
Improve error message when dataset mixes cloud and...
on:
Org apps per app and workbooks with custom message...
on:
Deployment pipeline rule for data factory pipeline...
on:
Epic Idea: Show visual dependencies for bookmarks
dm-p
on:
Allow standard Focus Mode for custom visuals that ...
This is now possible thanks to the new Execute queries API.
Here's the link for the announcement: Evaluate Power Query Programmatically in Microsoft Fabric (Preview) | Microsoft Fabric Blog | Micros...
And the link to the official REST API endpoint documentation: Query Execution - Execute Query - REST API (Dataflow) | Microsoft Learn