Skip to main content
Microsoft Idea

Power BI

New

Add 'view native SQL query' to Visual Query in Datamart

Vote (4) Share
Luca Zanna's profile image

Luca Zanna on 14 Aug 2022 18:35:46

The visual query in Datamart is great to start building a query visually.


The next steps I imagine are:

  • use that query in Power BI -> can we add this possibility ?
  • look at the native SQL of the query, then customize it even further using the SQL editor


Are these 2 functionalities already planned?


thank you for the great work on Power BI and the exciting Datamart

Comments (1)
Luca Zanna's profile image Profile Picture

Olivier Travers on 13 Feb 2023 21:26:18

RE: Add 'view native SQL query' to Visual Query in Datamart

  • You can already view the native query by right clicking on the visual step of your choice.
  • You could then copy/paste that query as a native query against the datamart's SQL endpoint.