Problem with visual query in Microsoft Fabric

[EllenHeijmans1]

I created in Microsoft Fabric a visual query. I added the tables dimProduct and FactInternetSales and merged them (see image). 

When I click View SQL or Save as View, I only get to see the select statement for the first table. Even when I click HighLight related queries or select the very last step.

It doesn't matter whether I start with dimProduct or factInternetSales. It only shows the SQL-code of one table and not of the combination of both. 

Can anyone shed some light on this? It must be possible to see the SQL code of all the steps.

[EllenHeijmans1]

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]

Hi @EllenHeijmans1 

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!

[suparnababu8 · Accepted solution]

Hi @EllenHeijmans1 

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!