Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
Working on MS Fabric, in the Lakehouse SQL endpoint, I created a Visual Query:
in this visual query, I am appending two tables. Is it possible to save the results as a Table? I tried everything and I cannot because this option is not available. I can only see "Download or Visualize".
I can only save the results as a table, if I write a SQL query because it gives me this option:
Thank you very much for any assistance you could provide.
Best regards.
Hello @Luci7 ,
Thanks for using the Fabric community .
I dont think you can do that , but you can use the "View SQL" Option the Visual Query and then paste the query in the "New SQL query " .
Thanks
HImansh
Hello @HimanshuS-msft and thank you for your help. I tried to do as you said, but when you append data_table and data_table (2) in your example, the "view SQL" only shows, for me, the SQL query of one table and not the new created appended table. Could you kindly see if you are able to reproduce this issue?
Thank you very much!
Kind regards,
Luci
Check out the April 2024 Fabric update to learn about new features.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
User | Count |
---|---|
10 | |
10 | |
8 | |
5 | |
4 |