topic SQL Endpoint - Error 5 Access Denied in Developer

SQL Endpoint - Error 5 Access Denied

Jameopw — Fri, 25 Oct 2024 11:51:59 GMT

Hi!

I am having issues with my SQL endpoints. When running my dataflow Gen2s, I'm getting the following error:

I also cannot access the SQL endpoint in the lakehouse explorer:

This is on all of my Lakehouses in my Fabric workspace. Any idea of how I can fix this? Nothing has changed that I can think of to trigger this issue. I have checked also, and the oweners/creators of the lakehouses have not changed/been deactivated.

Hope someone can help as I am very reliant on Dataflows for the engineering pipeline & cannot proceed until the issue is fixed!

Many thanks in advance!

Re: SQL Endpoint - Error 5 Access Denied

Anonymous — Mon, 28 Oct 2024 08:11:38 GMT

Hi @Jameopw ,

Base on your description, it seems to be a permission issue. Could you please provide the following info for further trouleshooting?

Are you the owner of lakehouse currently? It need both read and write permissions.
Are you a member or admin role in your Fabric workspace?
Please provide the error message details in below screenshot

Best Regards

Re: SQL Endpoint - Error 5 Access Denied

Jameopw — Mon, 28 Oct 2024 09:24:54 GMT

I am not the owner of the lakehouse, but I am the only user in the workspace and have full admin rights. Looking at other forum questions, it could be the lakehouse ownership that's causing problems.

These are my current permissions for the lakehouse:

The error details are only as follows unfortunately.

When I follow the 'Help' link, it takes me here: https://learn.microsoft.com/en-us/fabric/data-warehouse/troubleshoot-synapse-data-warehouse

Re: SQL Endpoint - Error 5 Access Denied

Anonymous — Tue, 29 Oct 2024 07:33:30 GMT

Hi @Jameopw ,

Please take over SQL endpoint using Powershell scripts:

 # Install the Power BI PowerShell module if not already installed 
   Install-Module -Name MicrosoftPowerBIMgmt 

 # Import the Power BI PowerShell module 
   Import-ModuleMicrosoftPowerBIMgmt 

 # Connect to the Power BI service using the new owner credentials and take over the SQL Endpoint

   $workspaceid = "xxx"
   $sqlendpoint = "xxx"

   Connect-PowerBIServiceAccount

   $url = 'groups/' + $workspaceid + '/lhdatamarts/' + $sqlendpoint + '/takeover' 
   write-host $url 
   Invoke-PowerBIRestMethod -Url $url -Method Post -Body ""-Verbose

And check if it hit any following limitations:

Best Regards