Forum Discussion
Problem with visual query in Microsoft Fabric
You need to enable your FactInternetsales Query shoild be active. Then only you will be able to save SQL query with all steps. Please follow below steps.
Now in the below image gold_customer is highlighted with blue border.
Now I perfomed the join and did some transformations, you can see Merge Query. Now right click on the Merge and selelct enable.
Now you will see Merge is highlighted with blue background color.
Now click on View SQL/Save as view you can see the full scripti of final query.(Merge in this case)
Now fro here you can see only the table with load enabled selected will show the corresponding SQL script.
You will not able to see all steps perfomred under the visual query. It's known limitation from Documentation. Pls refere teh below
Please go through this thread Query Using the Visual Query Editor - Microsoft Fabric | Microsoft Learn
Hope you are clear now.
let me know if it helps you!
Thank you!
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
I don't know what I am doing wrong. I put two tables on the visual query and choose Merge Queries as New. I clicked Enable Load. But still I see the SQL of 1 query. I can even, when I click the plus and choose Group By, choose columns from the dimProduct table.
- suparnababu8
Super User
After join, you can do any trasformations and try to save it as SQL query.
Note: Transofrmations will not be recorded in SQL query.
Pls try in this way and let me know.
Thank you!
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!