Sarah Sh
Sarah Sh

Reputation: 519

Unable to connect from Power BI to Azure DocumentDB

I am trying the Power BI with the tutorial: https://learn.microsoft.com/en-us/azure/cosmos-db/powerbi-visualize#prerequisites

Trying to connect to the demo DB (URL: https://analytics.documents.azure.com) I get the error: Details: "The specified database was not found."

Upvotes: 1

Views: 1120

Answers (2)

Indika R
Indika R

Reputation: 61

I am having the same issue. BUT, I found a workaround to get connected to my Cosmos DB from Power BI Desktop using "Microsoft Azure Cosmos DB ODBC driver" for windows.

Reference article on odbc driver: link.

Upvotes: 0

Foxan Ng
Foxan Ng

Reputation: 7151

The workaround is to start with an empty query and enter the formula manually:

let
    Source = DocumentDB.Contents("https://analytics.documents.azure.com", null, null)
in
    Source

Results:

results

Upvotes: 3

Related Questions