Forum Discussion
Helper IIIExport to Excel in SQL Endpoints / Warehouses is still not working.
Will the function to export a Query to Excel ever work? Been using Fabric for almost a year now and this has not once worked.
I am talking about this option here:
Even the label is currently bugged as it used to only say Analyze in Excel.
You are prompted to select the SELECT statement from the Query Editor, but the resulting Excel file is always empty. This has never worked since Fabric launched. I understand this is probably a bug and a ticket must be submitted, but I perhaps there is a workaround I am missing.
Hi JosueMolina ,
Thanks for the reply from lbendlin / FabianSchut .
I did some testing and could not reproduce your error, the “AnalyzeInExcelASonPremWarning_OpenInExcel” option worked fine for me.
Below are my test steps:
1. After running the SQL statement in warehouse, select the SQL statement and click on “AnalyzeInExcelASonPremWarning_OpenInExcel”, an excel file will be downloaded.
2. Just open the excel is blank, need to enable editing.
3. Click enable content to configure the connection information, and sign in with the account that is logged in the power bi service.
4. This prompt appears, click connect on it.
5. It works fine.
Please check your steps again, if the problem still exists, can you please share your steps with me, preferably in the form of moving pictures.
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
11 Replies
- lbendlin
Super User
Have you tried to connect to the SQL endpoint directly from Excel (via the Azure SQL database connector)?
JosueMolinaYes. I am able to connect to the SQL Endpoint as an Azure SQL Database connection using vscode, DBeaver and other tools.
But given there is an intended option to extract directly a single quick ad-hoc query, I'd like to see if there is a way to get it working.
- FabianSchut
Solution Sage
Hi JosueMolina,
I personally use Azure Data Studio to create some ad-hoc queries connected to the Fabric Warehouse/Lakehouse. Within Azure Data Studio, you have the ability to directly export this to Excel (and CSV, JSON, Markdown, XML or see it as a chart). I think this option can work for you too. You can install Azure Data Studio here:
https://learn.microsoft.com/en-us/azure-data-studio/download-azure-data-studio?view=sql-server-ver16&tabs=win-install%2Cwin-user-install%2Credhat-install%2Cwindows-uninstall%2Credhat-uninstall- JosueMolina
Hi! Thanks FabianSchut , but I am interested in understanding if there is a way to get the Analyze in Excel option working within the Warehouse itself. We've been resorting to an external connection to the Warehouse / Endpoint already to get the information we require at times. Given that we have a LARGE amount of Lakehouses/Endpoints/Warehouses, we must establish a new connection for each. Doing this for a one time query is inefficient.
Appreciate the help, but once again, I am interested in getting the button to work or getting an Excel file directly from the Fabric experience without resorting to SQL connections via another software.- lbendlin
if there is a way to get the Analyze in Excel option working within the Warehouse itself.It's a warehouse, not a cube. Analyze in Excel only works with cubes.
Hi JosueMolina ,
Thanks for the reply from lbendlin / FabianSchut .
I did some testing and could not reproduce your error, the “AnalyzeInExcelASonPremWarning_OpenInExcel” option worked fine for me.
Below are my test steps:
1. After running the SQL statement in warehouse, select the SQL statement and click on “AnalyzeInExcelASonPremWarning_OpenInExcel”, an excel file will be downloaded.
2. Just open the excel is blank, need to enable editing.
3. Click enable content to configure the connection information, and sign in with the account that is logged in the power bi service.
4. This prompt appears, click connect on it.
5. It works fine.
Please check your steps again, if the problem still exists, can you please share your steps with me, preferably in the form of moving pictures.
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!- JosueMolina
Forgot to reply here. While this is not what I was looking for and I was unable to get my connection to work, this does seem to be the intended way of working with this option.
Hi JosueMolina ,
Is my follow-up just to ask if the problem has been solved?
If so, can you accept the correct answer as a solution or share your solution to help other members find it faster?
Thank you very much for your cooperation!
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
