Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Cosmos DB basd DataSet authentication where local auth is disabled in cosmos DB

I recently needed to disable Local Auth on cosmos DB collection, preventing the ability to auth using key based tokens.  In doing, several users power BI reports are now unable to refresh a data set...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi,Anonymous 

Based on the information I've gathered so far, the Power BI Connector currently only supports Azure Cosmos DB SQL API and Gremlin API accounts in powerbi without Feed Key authentication. It does not currently connect to the Power BI connector.

Here is the detailed link:
Solved: Cosmos DB connection issuee - Page 2 - Microsoft Fabric Community
 

​​Therefore, you can also try to connect Azure Cosmos DB to Power BI using Azure Synapse Link for Azure Cosmos DB.

Here's an official screenshot of that section:
 

 

 

 

Here is the detailed link:
Power BI tutorial for Azure Cosmos DB | Microsoft Learn
 

​Here are some links that may be helpful to you if you have similar questions:
Solved: Connecting Azure Cosmos DB to Power BI - Microsoft Fabric Community
Issues using Cosmos Explorer with Local Auth Disabled · Issue #1470 · Azure/cosmos-explorer · GitHubSolved: Cosmos db connection in Power BI - Microsoft Fabric Community


Of course, if you have any new ideas, you are welcome to contact us.
 

Best Regards,

Leroy Lu

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