Forum Discussion

BenBernanke's avatar
BenBernanke
Frequent Visitor
2 years ago

Trying to connect to Fabric Data from SQL endpoint in Excel

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: -...
Need Help
Fowmy's avatar
Fowmy
Super User
2 years ago

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:

 



BenBernanke's avatar
BenBernanke
Frequent Visitor
2 years ago

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.