Blocking access to specific tables

Question

We have PowerBI Users that are now asking for access to our database as datareaders. I have added a new User, provided the Username/Password to them. However, I would like to block access to two specific tables due to sensitive information.

The entire database just uses dbo as the schema. How do I block access to specific tables?

Answer 1

A simple deny should be all you need to do:

deny select on object::dbo.<table> to <user>;