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?
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
105 | |
77 | |
72 | |
48 | |
47 |
User | Count |
---|---|
158 | |
86 | |
80 | |
68 | |
66 |