topic Re: Trying to connect to Fabric Data from SQL endpoint in Excel in Developer

Trying to connect to Fabric Data from SQL endpoint in Excel

BenBernanke — Sat, 30 Mar 2024 08:23:06 GMT

Hey all,

So Im trying to connect to my Fabric Data in a lakehouse from Excel using the "Connect to SQL Database" and then putting in the connection string of the lakehouse.

A few problems:

-When I connect on my personal computer it says "Exceeded Fabric Capacity" but havent ran anything recently this month. Not sure if this is a persmissions issue.

-I set up a virtual network to try and connect on work computer that is behind a VPN. Used the personal data gateway march update but still cannot connect to my lakehouse.

When I do try and setup a virtual network data gateway in Fabric I get this error:
Unable to validate the subnet permissions required to join the subnet to the Microsoft Power Platform service. Error details: Request rejected with status 400 and message {"error":{"code":"BadRequestFormat","message":"The ObjectID must provided for groups expansion."}}

Going to guess this is also a permissions problem.

Any help is greatly appreciated.

Re: Trying to connect to Fabric Data from SQL endpoint in Excel

Fowmy — Sat, 30 Mar 2024 09:14:35 GMT

BenBernanke

I too tried to connect to an SQL Endpoint of a Lakehouse from Excel and got the same error message. I have a trial subscription and I believe the same with you as well.

One option is to connect to the Semantic Model if you are fine with that:

Re: Trying to connect to Fabric Data from SQL endpoint in Excel

BenBernanke — Mon, 01 Apr 2024 07:30:19 GMT

Hey!

Thanks for pointing that out. I did try and connect via the semantic PowerBI models but still got nothing. I think because we are behind a VPN we need a VNET Data Gateway but I get that error above when trying to make a VNET Data Gateway in Fabric:
Unable to validate the subnet permissions required to join the subnet to the Microsoft Power Platform service. Error details: Request rejected with status 400 and message {"error":{"code":"BadRequestFormat","message":"The ObjectID must provided for groups expansion."}}

Thank you again! Let me know if you know anything about the error.

Re: Trying to connect to Fabric Data from SQL endpoint in Excel

Vogels — Thu, 18 Apr 2024 09:31:05 GMT

BenBernanke do you have any additional insights on this issue?

We are facing the same issue and I don't think it firewall, permissions of capacity limit issue.

Because I can connect to the SQL endpoint with Azure Data Studio while connected to the same VPN and home network.

Also I have this issue both with the trail and paid capacity of which I am the admin so permissions doesn't seem likely to me.

And I have verified that our capacity has not been fully used.

Anything you can share would be helpful.