PowerBI & OKTA & PostgreSQL

[Anonymous]

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. 

[v-juanli-msft]

Hi @Anonymous

Please read this aricle and these discussions under the thread to get some useful ideas.

Best Regards

Maggie

[Anonymous]

Thanks for the reply I checked both the artical and thread which mentioned how to connect PostgreSQL but it still doesn't answer my questions. Is there a way with a direct connecion (not import connection) so that PowerBI will set session variables taken from the user profile on OKTA?