Apart from Excel and power bi. where we can use power query?

[lavdeepk]

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

[negi007 · Accepted solution]

@lavdeepk 

Yes, it is mostly used in Ms-Excel and MS-PowerBI. But now it's engine is used in other MS application as well. 

Where can you use Power Query?

The following table lists Microsoft products and services where Power Query can be found.

WHERE CAN YOU USE POWER QUERY?

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

WHERE CAN YOU USE POWER QUERY?

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

https://docs.microsoft.com/en-us/power-query/power-query-what-is-power-query#where-can-you-use-power...

https://chandoo.org/wp/power-query-tutorial/#:~:text=Power%20Query%20is%20used%20to,system%20%E2%80%...

[watkinnc]

The Power Automate SQL connector.

--Nate