Visual Query Editor in Datamart (or could be in Fabric) - Build from blank with SQL Query

[jmg80525]

Playing around with Visual Query editor in the datamart.  Looks to be the same experience as in Fabric without the bells and whistles to commit table, views, etc.  With the regular power query editor, I can open a blank query and paste in M code and all the steps are presented in editor.  Can I in the same manner, open a blank visual query, paste in the SQL and have it build the visual query?

Use case is looking for a means to back up visual queries. Once you have one in desired state, you can view (and edit) the SQL. I would fork this is off into a repository for safe keeping.  I can then place it into shared queries for team consumption and not worry about someone stomping on it.  I tried creating a new visual query, drop a table in it to enable the View SQL button, view it, edit it and the close it, but it just give me a SQL query.  I'm not seeing any way to round-trip it, but thought I may be missing something.

[v-venuppu]

Hi @jmg80525 ,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please accept it as a solution and give it a 'Kudos' so other community members with similar problems can find a solution faster.

Thank you.

[v-venuppu]

Hi @jmg80525 ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-venuppu]

Hi @jmg80525 ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[Akash_Varuna · Accepted solution]

Hi @jmg80525 I think currently the Visual Query Editor in Datamart (or Fabric) doesn't support directly building a visual query from pasted SQL. Although as a workaround, you can try creating a new visual query, adding a dummy table, and replacing its SQL with your custom query. While this executes the SQL, it won’t generate a step-by-step visual representation. For backups, you’ll need to save the SQL separately in a repository.
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance