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

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 Specialist
Solution Specialist

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

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors