Warehouse SQL Endpoint "Open in Excel" Error

[MDaiy]

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!

[MDaiy · Accepted solution]

Hello,

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

[Jeanxyz]

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

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

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 .

[Anonymous]

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 .