Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I am aware of only two applications Excel and Power Bi where I can use power query. Is there any other Microsoft tool where I can use power query?
Thanks
Lavdeep
Solved! Go to Solution.
Yes, it is mostly used in Ms-Excel and MS-PowerBI. But now it's engine is used in other MS application as well.
The following table lists Microsoft products and services where Power Query can be found.
Product | M engine1 | Power Query Desktop2 |
Power Query Online3 |
Dataflows4 | |
---|---|---|---|---|---|
Excel for Windows | Yes | Yes | No | No | |
Excel for Mac | Yes | No | No | No | |
Power BI | Yes | Yes | Yes | Yes | |
Power Apps | Yes | No | Yes | Yes | |
Power Automate | Yes | No | Yes | No | |
Azure Data Factory | Yes | No | Yes | Yes | |
SQL Server Integration Services | Yes | No | No | No | |
SQL Server Analysis Services | Yes | Yes | No | No | |
Dynamics 365 Customer Insights | Yes | No | Yes | Yes |
1M engine | The underlying query execution engine that runs queries expressed in the Power Query formula language ("M"). |
2Power Query Desktop | The Power Query experience found in desktop applications. |
3Power Query Online | The Power Query experience found in web browser applications. |
4Dataflows | Power Query as a service that runs in the cloud and is product-agnostic. The stored result can be used in other applications as services. |
Links for further reading
Proud to be a Super User!
Yes, it is mostly used in Ms-Excel and MS-PowerBI. But now it's engine is used in other MS application as well.
The following table lists Microsoft products and services where Power Query can be found.
Product | M engine1 | Power Query Desktop2 |
Power Query Online3 |
Dataflows4 | |
---|---|---|---|---|---|
Excel for Windows | Yes | Yes | No | No | |
Excel for Mac | Yes | No | No | No | |
Power BI | Yes | Yes | Yes | Yes | |
Power Apps | Yes | No | Yes | Yes | |
Power Automate | Yes | No | Yes | No | |
Azure Data Factory | Yes | No | Yes | Yes | |
SQL Server Integration Services | Yes | No | No | No | |
SQL Server Analysis Services | Yes | Yes | No | No | |
Dynamics 365 Customer Insights | Yes | No | Yes | Yes |
1M engine | The underlying query execution engine that runs queries expressed in the Power Query formula language ("M"). |
2Power Query Desktop | The Power Query experience found in desktop applications. |
3Power Query Online | The Power Query experience found in web browser applications. |
4Dataflows | Power Query as a service that runs in the cloud and is product-agnostic. The stored result can be used in other applications as services. |
Links for further reading
Proud to be a Super User!
The Power Automate SQL connector.
--Nate
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.