Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

"Download Excel File" in Fabric SQL Query Editor not working

The "Download Excel File" button does not appear to work in the Fabric SQL Query editor on a Warehouse. As instructed, I am selecting the SELECT statement which produces the table which I want to exp...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi,
Apologies for the issue you're experiencing. I tried this scenario and I'm unable to reproduce this issue on my end. I am able to download the excel file and also load the data into it. I have attached the screenshots for your reference.
Can you please check if your organization has turned off export to Excel in the tenant settings?
Can you also provide the .har file to me for us to troubleshoot this issue further? Here's instructions on how you can do that: How to collect a network trace | Microsoft Learn

 



 

 

daxman's avatar
daxman
Advocate II
2 years ago

I can confirm that my Tenant Settings allows for Exporting to Excel across the entire organization: 

 

When I ran the Network trace, indeed there was an error for "xlsx" name with the status code "400: Bad Request".

How should I provide you with the .har file?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi daxman ,
    I have attached a link about how to get a har file. Please follow those steps and send me the har file.
    Thanks

    • daxman's avatar
      daxman
      Advocate II
      2 years ago

      I already have the .har file, I am asking how can I send it to you? I do not see an option to add an attachment to the post.

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago




        Hi daxman ,
        Please attach the .har file along with your post. I have attached the screenshot for your reference.