topic Re: Warehouse SQL Endpoint "Open in Excel" Error in Data Warehouse

Warehouse SQL Endpoint "Open in Excel" Error

MDaiy — Thu, 04 Apr 2024 17:29:48 GMT

We have recently set up a data warehouse in Fabric, and when attempting to use the "Open in Excel" feature in the query editor, I get the follwing error message in Excel:

I did some research online and found that this is typically an auth issue that extends to Power BI, but I am able to get data in Power BI without issue. Any insight on this problem would be greatly appreciated!

Re: Warehouse SQL Endpoint "Open in Excel" Error

Anonymous — Fri, 05 Apr 2024 09:36:01 GMT

Hi MDaiy ,

Thanks for using Fabric Community.

I am not facing any issue while I try to Open in excel.

I would like to understand are you facing this issue for particular lakehouse or for any lakehouse.
Are you still facing the issue, please let us know with further details so that we can guide you.

Re: Warehouse SQL Endpoint "Open in Excel" Error

Anonymous — Mon, 08 Apr 2024 11:28:22 GMT

Hello MDaiy ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.
In case if you have any resolution please do share that same with the community as it can be helpful to others .
Otherwise, will respond back with the more details and we will try to help .

Re: Warehouse SQL Endpoint "Open in Excel" Error

Anonymous — Wed, 10 Apr 2024 08:09:42 GMT

Hi MDaiy ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.
In case if you have any resolution please do share that same with the community as it can be helpful to others .
Otherwise, will respond back with the more details and we will try to help .

Re: Warehouse SQL Endpoint "Open in Excel" Error

MDaiy — Mon, 15 Apr 2024 16:15:04 GMT

Hello,

This ended up being an error with our internal IT controls. Changing the auth settings resolved it.

Re: Warehouse SQL Endpoint "Open in Excel" Error

Anonymous — Tue, 16 Apr 2024 10:43:22 GMT

Hi MDaiy ,

It was great to know that you were able to get to a resolution . We expect you to keep using this forum and also motivate others to do that same . You can always help other community members by answering to their queries

Re: Warehouse SQL Endpoint "Open in Excel" Error

Jeanxyz — Sun, 19 Jan 2025 22:15:54 GMT

Hi MDaiy , I have the same error message. Could you please explain in more detail how to solve this issue?