PowerBI & OKTA & PostgreSQL

I'm trying to connect PowerBI to our PostgreSQL database for the visual reporting. We also use OKTA SSO to manage all of our users between the different systems. We are planning to use a direct connection as our data often changes and it already manipulated. The best approach would be to have a single PostgreSQL user that PowerBI is using to connect and have session level row level permission based on profile attributes coming from OKTA SSO. Based on some research I did it seems the only way to integrate SSO and row level permissions is if each client has it own PostgreSQL user and PowerBI will use that user to communicate with PostgreSQL, Am I right? or there is a better way? Also if you have any ideas or tutorials you recommend I read before integrating this 3 platform it will be really helpful.