Power BI and MongoDB Connectivity

[supriyad]

Hi All,

We have stored huge records of sensors data in our MongoDB database.

Now our moto is to connect this database to Power BI and build various reports which will give us real time scenario or health of all sensors. And also dashboard data should be LIVE.

For this purpose I am using MongoDB ODBC Driver for Windows downloaded from here . And have followed these steps.

But when I am trying for testing the connection then I am getting following set of errors :

1. Details: "ODBC: ERROR [HY000] [DataDirect][ODBC MongoDB driver][MongoDB]java.lang.OutOfMemoryError: Java heap space ERROR [HY000] [DataDirect][ODBC MongoDB driver][MongoDB]java.lang.OutOfMemoryError: Java heap space"
2. Details: "ODBC: ERROR [42000] [DataDirect][ODBC MongoDB driver][MongoDB]syntax error or access rule violation: invalid schema name: DIGITAL ERROR [42000] [DataDirect][ODBC MongoDB driver][MongoDB]syntax error or access rule violation: invalid schema name: DIGITAL"

If I am reducing number of records from the respective database then at that time connection gets established easily, but when I am trying to hit LIVE data then I am getting either of the above errors continuosly.

For resolving error 1 I have increased to Heap Space upto 3GB but still I am getting same error.

So is anybody facing same issue? What should I do to get mongoDB data into Power BI? Or Is there any other way to get LIVE mongoDB data into Power BI and display it within some seconds?

Please help.

Thanks in advanced.

[v-yuta-msft]

Hi supriyad,

To make data in dashboard be LIVE, user should create a streaming dataset. So are you creating a streaming dataset with data in MongoDB Database using rest API? If so, could you post some code or screenshot of that part in your program?

Regards,

Jimmy Tao