How to connect Cosmos DB and Azure SQL Server via Direct query and apply RLS in Power BI?

[Anonymous]

Hi, I have data in two databases
1. Azure SQL Server
2. Azure Cosmos DB
Azure Cosmos DB Contains all the Sales related information and refreshes at every 10 minutes.
Azure SQL Server contains all the user and role related information

Now, the requirement is to prepare a Power BI report which shows realtime data with RLS.
and then i want to embed this report in a web app.

Cosmos DB connector in Power bi is not supporting the Direct query mode.

How can i Analyze the realtime data in this scenario?

can we apply RLS with two seperate database tables (direct query)?

[v-lionel-msft]

Hi @Anonymous ,

"Cosmos DB connector in Power bi is not supporting the Direct query mode."

Yes, the main problem is that it does not support Direct Query mode.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.