Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
@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.
@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:
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
37 | |
4 | |
3 | |
2 | |
2 |