Forum Discussion

prateekraina's avatar
prateekraina
Icon for Memorable Member rankMemorable Member
8 years ago

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

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 ...
Interesting Links
Show and Tell
Tips and Tricks
bfeenstra's avatar
bfeenstra
New Member
8 years ago

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's avatar
    prateekraina
    Icon for Memorable Member rankMemorable Member
    8 years ago

    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