Forum Discussion
SQL-Endpoint not working anymore
I've found the issue. The user who created the Warehouses/Lakehouses has been deactivated.
Du to the Warehouses using delegate Permissions from the Owner for other users to access the Data, the User cannot be removed from the Workspace or Access will break.
According to the following Guide PowerShell can be used to change Ownership.
Change ownership of Fabric Warehouse - Microsoft Fabric | Microsoft Learn
However so far this only worked with Warehouses and NOT Lakehouses for me.
Hope this helps! ... and i find out how to fix the Lakehouses
EDIT:
Microsoft confirmed that the Owner of Lakehouses currently can only be changed by them. So you'll have to open a Ticket. They plan to allow the end user to change that in the future.
I don't understand why the Access to the Warehouses is not managed via Service Principal (like other Services) instead of User Delegation but it is what it is.
Hi Timal ,
Have you renamed Lakehouse or Warehouse? Trying to access the SQL endpoint or Warehouse item using client tools after renaming may encounter failures.
If the suggestions above do not help you, could you provide some details such as whether the error is persistent or intermittent, and whether you have done anything else prior to the error. Detailed information can help us better understand and solve the problem you are experiencing.
Best Regards,
Ada Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Forgot to answer the remainder of your question.
We haven't changed any configuration. Built a Dataflow the day before and it was working fine suddenly the day after nothing works anymore.
Thanks