cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lavdeepk
Helper III
Helper III

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

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

1 ACCEPTED SOLUTION
negi007
Super User II
Super User II

@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%...

 

 




Did I answer your question? Mark my post as a solution!
Appreciate your Kudos


Proud to be a Super User!

Follow me here


View solution in original post

2 REPLIES 2
negi007
Super User II
Super User II

@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%...

 

 




Did I answer your question? Mark my post as a solution!
Appreciate your Kudos


Proud to be a Super User!

Follow me here


View solution in original post

watkinnc
Solution Sage
Solution Sage

The Power Automate SQL connector.

--Nate

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors