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:

     

alfBI's avatar
alfBI
Responsive Resident
1 year ago

Ho v-lgarikapat,

 

Sorry, I use the word OLS erroneously.

 

Our aim is to prevent that a power BI desktop user might access certain tables of the warehouse when implementing a new semantic model using the warehouse sql end point.

 

We tried to do it exactly what do you mention (using T-SQL GRANT/DENY statements for access control), but it seems not to work (see above screenshots). 

 

Any idea about it does not work as expected?