Can Power BI Online Connect to Azure DocumentDB Has anyone successfully connected Power BI Online to Azure DocumentDB Cosmos DB What s the best approach

0 votes
Can Power BI Online Connect to Azure DocumentDB? – Has anyone successfully connected Power BI Online to Azure DocumentDB (Cosmos DB)? What’s the best approach?

Has anyone successfully connected Power BI Online to Azure DocumentDB (Cosmos DB)? What is the best approach for establishing a direct connection, and are there any limitations or best practices to consider?
1 day ago in Power BI by Evanjalin
 • 13,180 points • 35 views

1 answer to this question.

0 votes
Definitely, yes, Power BI Online is able to connect Azure Cosmos DB (Formerly DocumentDB) in a number of different ways:

Azure Cosmos DB Connector

Available in Power BI Desktop for importing data directly.
For an automatic update, use DirectQuery mode.
Publish to Power BI Service using a gateway to schedule a refresh.
ODBC/Custom API:

Use the Azure Cosmos DB ODBC Driver to connect.
Alternatively, please set up a REST API or Azure Function to get data and push it to Power BI through a Streaming Dataset.
Best Practices and Limitations:

Performance: Optimize your queries so you will not overrun the RU limit.
Data Refresh: Power BI Online needs an on-premises data gateway for scheduled refresh.
Security: Use Managed Identity or Service Principals for authentication
answered 1 day ago by anonymous
 • 13,180 points

Related Questions In Power BI

0 votes
0 answers

What’s the best approach to handling slowly changing dimensions (SCD) in Power BI?

What’s the best approach to handling slowly ...READ MORE

Nov 7, 2024 in Power BI by Evanjalin
 • 13,180 points • 84 views
0 votes
1 answer

What’s the best approach to handling slowly changing dimensions (SCD) in Power BI?

Working with slowly changing dimensions (SCDs) in ...READ MORE

answered Nov 12, 2024 in Power BI by pooja
 • 14,220 points • 115 views
0 votes
1 answer

What’s the best approach to handle text-based data in Power BI, especially when applying search or pattern-matching transformations?

Dealing with text data in Power BI, ...READ MORE

answered Nov 12, 2024 in Power BI by pooja
 • 14,220 points • 120 views
0 votes
0 answers

What’s the best approach to handle non-tabular data sources (e.g., unstructured data) in Power BI?

What’s the best approach to handle non-tabular ...READ MORE

Nov 18, 2024 in Power BI by Evanjalin
 • 13,180 points • 79 views
0 votes
1 answer

Displaying Table Schema using Power BI with Azure IoT Hub

Answering your first question, Event Hubs are ...READ MORE

answered Aug 1, 2018 in IoT (Internet of Things) by nirvana
 • 3,130 points • 1,479 views
+1 vote
1 answer

Unable to install connector for Power Bi and PostgreSQL

I think the problem is not at ...READ MORE

answered Aug 22, 2018 in Power BI by nirvana
 • 3,130 points • 2,839 views
+2 votes
2 answers

Migrate power bi collection to power bi embedded

I agree with Kalgi, this method is ...READ MORE

answered Oct 11, 2018 in Power BI by Hannah
 • 18,520 points • 1,614 views
+1 vote
1 answer

Connect power bi desktop to dataset and create custom reports

Yes using Power BI REST API to ...READ MORE

answered Sep 18, 2018 in Power BI by Kalgi
 • 52,350 points • 1,753 views
0 votes
1 answer

Power BI Retention Policy – How to Implement FIFO? – What’s the best way to set up a basic FIFO (First-In-First-Out) retention policy in Power BI?

Implementing a FIFO (First In, First Out) ...READ MORE

answered 2 days ago in Power BI by anonymous
 • 13,180 points • 29 views
0 votes
1 answer

How we can automate the deployment of PBIX reports to Power BI Report Server and changing Datasource connection string Pro-grammatically.?

It is good to automate the deployment ...READ MORE

answered 1 day ago in Power BI by anonymous
 • 13,180 points • 27 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.