Connect Power BI with Azure Cosmos DB Emulator / Local Document DB / Local Cosmos DB

[prateekraina]

Hi Guys,

I am writing this post to just share this information that we can connect to On Prem Azure Cosmos Cosmos DB earlier called Document DB using Power BI Desktop. I don't know if anyone has explored this but it can be very useful in many IOT scenarios.

After downloading & installing Azure Cosmos DB Emulator, you can connect to the On Prem Cosmos DB in the similar way you connect to the Azure Cosmos DB. Following are the detailed steps:

1. Click on Get Data in Power BI Desktop and choose Azure Cosmos DB.


2. Enter the localhost URL which is similar to this: https://localhost:8081/


3. Enter the Master Account Key when asked for Account Key.
    Master Key : C2y6yDjf5/R+ob0N8A7Cgv30VRDJIWEHLM+4QDU5DE2nQ9nDuVTqobD4b8mGGyPMbIZnqyMsEcaGQy67XIw/Jw==
    Details: Click here

4. And Bang!! You are connected to the On Prem Cosmos DB.


If any questions, drop me an email to pratyvoldy@gmail.com

Prateek Raina 

[bfeenstra]

I have connected to Cosmos DB via the Emulator and via the OBDC method, https://docs.microsoft.com/en-us/azure/cosmos-db/odbc-driver. When loading data, both of these methods max out at uploading roughly 123k rows of data. I get HTTP error code 429 (Too Many Requests) on the azure side of things and the rest of data is not loaded to Power BI. Any suggestion on how to fix? 

Brandon 

[prateekraina]

Hi @bfeenstra,

Sorry! No idea about that. Why don't you directly use Azure Cosmos DB data source instead of ODBC. That might resolve your issue.

Prateek Raina

[v-jiascu-msft]

Thanks for sharing.

Best Regards,

Dale