Forum Discussion
How to connect Cosmos DB and Azure SQL Server via Direct query and apply RLS in Power BI?
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...
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.