Hi Geeks,
I was trying to connect mongoDB database with PowerBI desktop. I had installed BI connector, Mongo ODBC driver and even connected the database with PowerBI but i got a error when i click on Load. I need a immediate help. Thank you all in advance.
Solved! Go to Solution.
hi, @v-lili6-msft
Thank you so much for your response. I already fixed the issue. The thing is we need to specify not just tge database but also the table while creating a mongoDB DSN in odbc .
With regards,
AVINASH S KURUP
hi, @Anonymous
I have tested on my side, but not reproduce the issue.
Here is a tutorial for your reference:
https://docs.mongodb.com/bi-connector/master/connect/powerbi/
and check if you set up DSN correctly.
Best Regards,
Lin
hi, @v-lili6-msft
Thank you so much for your response. I already fixed the issue. The thing is we need to specify not just tge database but also the table while creating a mongoDB DSN in odbc .
With regards,
AVINASH S KURUP
I am new to the Power BI. Could you please elaborate on how to specify the table name while creating the system DSN for a mongodb database?
User | Count |
---|---|
114 | |
61 | |
60 | |
41 | |
37 |
User | Count |
---|---|
118 | |
66 | |
66 | |
65 | |
48 |