Forum Discussion

alfBI's avatar
alfBI
Icon for Responsive Resident rankResponsive 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
Icon for Community Support rankCommunity 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
Icon for Community Support rankCommunity 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.