Forum Discussion
Read Only DB User
For people searching for such a solution in the future: It's detached from Power BI and related to the database. We know extend the privileges by REFERENCES, so the user can do nothing except SELECT and REFERENCES and since he doesn't own a table or something else, a foreign key cannot be created. So he has the right to REFERENCE, but cannot use it at all.
Anonymous , power bi to read the schema(Schema Tables) to get the table and column name, make sure it has access to that
amitchandak Not sure, if I understood your answer. The read only user of course has read (SELECT) access to all the tables and columns in the schema. But SELECT only, no INSERT, UPDATE, DELETE, TRUNCATE. But for any reason it seems Power Bi forces the user to have not only SELECT access to the tables, at least when using Postgres. Otherwise, the relations / constraints between the tables are neither shown nor known when importing them into Power Bi.