Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
blndspt
Frequent Visitor

PowerBI Service (not desktop) to Mongo (Atlas)??

Hey guys,

 

I can't believe I'm actually asking this question.  Obviously, there are 100 articles on how to connect PowerBI DESKTOP to a Mongo database using ODBC.  However, I'm assuming that's not going to work the second you publish your report and dataset to the PowerBI service.  How in the world do you connect to Mongo in such a way that it works in desktop when you are building reports and then in 'Service' once you publish?

 

We were in Azure for awhile using Cosmos, in which case there is a direct connecter.  We moved to Atlas, now there seems to be no way to connect to MongoDB Atlas?

 

Thanks!

Scott

3 REPLIES 3
V-pazhen-msft
Community Support
Community Support

@blndspt 

As far as I know, it is not support to connect to ODBC sources in service. BTW, why do you need to connect to the database on service again? Once you publish to service, the model including data sources connection is together uploaded to the dataset in service, you can create and edit report as needed.

Best,
Paul

In order to refresh the dataset in the PowerBI service, it has to be able to connect to the data source?  Not really sure what you mean.  All I'm trying to find is a way to connect to Mongo that still works once you publish it to the PowerBI service (with the ability to refresh).  I'm assuming you cannot do this using ODBC.

 

Cosmos DB has a direct connector, for example. 

On that note, when will we see PowerBI able to connect to Cosmos with the Mongo API?  You can connect using the Cosmos SQL API, but no Mongo API support yet?  Geez!  And you still cannot connect to Cosmos yet with Dataflows!  I would have thought that Cosmos might have been Microsoft's 2nd connection after SQL Server. 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors