Empty excel file when "Open in Excel" from SQL analytics endpoint

[amaaiia]

I have a Lakehouse with several tables. I've opened SQL analytics endpoint view and launched a query from which I can see the results in the Results tab. I want to export these results to Excel, and I see the option "Open in Excel", where I first have to select the SELECT statement from which I want to export the result in Excel. I do it, then I click on Open in Excel, and I download a local Excel file that is empty when I open it.

Is there any option that I have to enable so that the content is exported and I don't download an empty excel?

[AndyDDC · Accepted solution]

Hi @amaaiia the Open in Excel feature doesn't export the results to excel, it downloads a connection to the sql endpoint.

the doc here talks about "download in excel" which I believe MS changed to "open in excel"

https://learn.microsoft.com/en-us/fabric/data-warehouse/sql-query-editor

[v-nikhilan-msft]

Hi @amaaiia 
Glad that your query got resolved. Please continue using Fabric Community for any help regarding your queries.