Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

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:   ...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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 ""-Verbose

    And check if it hit any following limitations:

    Best Regards

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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