Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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?