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

[davidBlount]

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, that was setup using a key embedded connection string,  that queries the collection. Is use of OAuth or, better still MSI\ Azure AppId , supported for power BI data sets?

I'm guessing it should be as it exists for other azure based data sets. I just thought I'd post here for confirmation, as I await specific details from the user with links to their power BI data set.

Thx

[Anonymous · Accepted solution]

Hi,@davidBlount 

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.