Forum Discussion

Regular Visitor

5 months ago

Ownership Chaining

Is Ownership Chaining not supported in Fabric Data Warehouse? If not, is there a plan to implement it?

Community Support

4 months ago

Hi sthoward0914,

Checking in to see if your issue has been resolved. let us know if you still need any assistance.

Thank you.

sthoward0914
Regular Visitor
4 months ago
Sorry, I'm on vacation with very spotty internet connectivity.

I can accomplish the task that way, yes, but is the solution Microsoft has offered the best solution? No. It's a lot of extra work in administration for reasons nobody seems to be able to explain. So it's a technically correct answer, but still suboptimal from an administrative perspective. So I got the answer, but an disappointed that is the answer.
- v-saisrao-msft
  Community Support
  4 months ago
  Hi sthoward0914,
  
  Currently, this is a design limitation in Fabric Data Warehouse rather than a best practice, and it results in extra administrative work compared to traditional SQL Server methods. The approach recommended by Microsoft is the supported option for now. If this behavior affects your situation, you might consider posting about it in the Microsoft Fabric Ideas forum; if it receives enough votes, it could be addressed in future updates.
  
  Fabric Ideas - Microsoft Fabric Community
  
  Thank you.