Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Is there anyway to connect to a MongoDB data source behind an enterpise gateway to get real time data updates?
Right now I know I can query MongoDB two ways
Both of these options work decently although the ODBC is extremely slow when going over 500K rows of data. Alot of the reports my company is building need to be real time reports. I can't have the data be stale for more than a minute. Our SQL databases that are behind the gateway all are able to use DirectQuery and they work great but alot of our new applications are using MongoDB and its really hurting the ability to use PowerBI
Hi @thmonte
I'm afraid there's no better ways.Below is the article for your reference.
https://dzone.com/articles/real-time-analytics-on-mongodb-data-in-power-bi
For 3rd party Links:
Please understand that this link is provided “AS IS” with no warranties or guarantees of content changes, and confers no rights.
Regards,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.