Forum Discussion

alfBI's avatar
alfBI
Responsive Resident
1 year ago
Solved

Granular access to specific objects within the Warehouse does not work using Power Desktop

Hi,   We have a Warehouse where we want to restrict access to certain tables when users connect to its SQL End Point. We followed the steps described here   https://learn.microsoft.com/en-us/fabr...
Warehouse
  • NandanHegde's avatar
    NandanHegde
    1 year ago

    Please follow the below steps  :

    My source Warehouse :

     

     

    Share the warehoue with the user to grant him/her connect access by disabling all features:

     

    Then login to Warehouse and execute the below queries :

    GRANT SELECT ON <<TableNme>> TO [<<[email protected]>>];
     
    Post that only specific objects are visible:

     

v-lgarikapat's avatar
v-lgarikapat
Community Support
1 year ago

Hi alfBI ,
Thank you for your follow-up question.

NandanHegde,
Appreciate your prompt and detailed response.

alfBI when you get a chance, could you please try the solution shared by NandanHegde ? It outlines a clear step-by-step approach that may help resolve the issue.

If you continue to experience any difficulties, please don’t hesitate to reach out. We're happy to support you further.

Looking forward to your feedback.

Reference:

Lakehouse sharing and permission management - Microsoft Fabric | Microsoft Learn

Best regards,
LakshmiNarayana

v-lgarikapat's avatar
v-lgarikapat
Community Support
1 year ago

Hi alfBI ,

 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please "Accept as Solution"

 

Best regards,
LakshmiNarayana.

  • v-lgarikapat's avatar
    v-lgarikapat
    Community Support
    1 year ago

    nikhiljoynj  Thank you for sharing the workaround and resolution  this is very helpful for other community members as well.

    alfBI  Did you have a chance to review the information provided by nikhiljoynj ? If so, please consider marking the most helpful reply as the Accepted Solution. Doing so helps others in the community find answers more efficiently when they encounter similar issues.

    If you’re still facing any challenges, feel free to let us know. We’re happy to assist further.

    Looking forward to your response.

    Best regards,
    Lakshmi Narayana

    • v-lgarikapat's avatar
      v-lgarikapat
      Community Support
      1 year ago

      Hi alfBI ,

       

      As we haven't heard back from you, we are closing this thread. If you are still experiencing the issue, please feel free to create a new thread we’ll be happy to assist you further.

      Thank you for your patience and support.

      If you found our response helpful, please mark it as Accepted Solution so others with similar queries can find it easily.

      Best Regards,

      Lakshmi Narayana