On Premise SQL Connection with SQL User Authentication not returning data

When connecting to a SQL server DB using a sql user that is a member of the db_datareader role on the database, the table names are visible but when you preview the data, the power bi desktop client ...