Note: This is not a Power BI issue, this is a DB credential issue.
In Power BI Desktop, I am trying to connect to a database, but I only want that user to have SELECT access.
I have one User that is a "sysadmin" under the Server Role and that works. But, that's too many permissions.
I created a new User and gave it Login Properties > Server Role = "public", then went into the database I need and gave it Membership > db_datareader. I thought this would work, but it doesn't. When I log into SSMS as that User and try to query that database, it says "The database {name} is not accessible." In Power BI, the error reads: "We couldn't authenticate with the credentials provided. Please try again".
Power BI Users: Yes, I am on the Database tab, not the Windows tab.