Forum Discussion
SQL Endpoint - Error 5 Access Denied
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!
Hi Anonymous ,
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 ""-VerboseAnd check if it hit any following limitations:
Best Regards
3 Replies
Hi Anonymous ,
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
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
Hi Anonymous ,
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 ""-VerboseAnd check if it hit any following limitations:
Best Regards