Forum Discussion

gerrysmith's avatar
gerrysmith
New Member
3 years ago

RLS on Cosmos DB

Hi,

 

The data soruce i have connected to is Azure Cosmos DB for PostgreSQL.

RLS is enabled on this database as it is for a multi tenant solution. When i connect to power bi, only public tables are accessible due to RLS on the data base and i am getting the following error - 
DataSource.Error: PostgreSQL: 42704: unrecognized configuration parameter "platform.current_organisation"

Platform is the database name. 

Do i need to do a direct query when connecting or write a specific sql statement before connecting so i can see private and public tables in the schema?

Role level security - multiple levels

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi gerrysmith ,

    Make sure that the account you use to connect to cosmos DB on power bi desktop has full access to the database.

     

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.