Forum Discussion

FredFred's avatar
FredFred
Frequent Visitor
1 year ago
Solved

SQL View created from Visual Query seems to be wrong

Hi Fabricators,   we used visual query for complex business logic and tried to translate it via "save as view" to SQL Statement. Turns out the result is not the same as it was in visual query. Stra...
data engineering
data pipeline
  • v-csrikanth's avatar
    v-csrikanth
    1 year ago

    Hi FredFred 
    Thank you for being part of the Microsoft Fabric Community.


    The behavior you're describing is likely caused by query caching in Microsoft Fabric’s visual query engine. Even if changes are reflected in the data preview (like when you click into the pop-up editor), when you "Save as SQL View," it may still generate SQL based on the previous cached schema.

    • After editing the source table, refresh the entire visual query (click "Refresh Preview") before saving it again.
    • Alternatively, close and reopen the visual query editor to force a full schema reload.


    If the above information helps you, please give us a Kudos and marked the Accept as a solution.
    Best Regards,
    Community Support Team _ C Srikanth.

v-csrikanth's avatar
v-csrikanth
Icon for Community Support rankCommunity Support
1 year ago

Hi FredFred 
To resolve the issue where "Show SQL" from a visual query only displays the initial table select, you need to enable load for each applied step in the visual query. This ensures that transformations are reflected when using "Show SQL" or "Save as View." You can also right-click specific steps in the visual query editor and select "View Data Source Query" to inspect SQL for individual transformations.

Note: Reference link which on of the user faces similar kind issue
https://community.fabric.microsoft.com/t5/Data-Engineering/Show-SQL-from-visual-query-not-possible/td-p/3503479 

 

If the above information helps you, please give us a Kudos and marked the Accept as a solution.
Best Regards,
Community Support Team _ C Srikanth.