Forum Discussion
Helper IVHow to connect to DocumentDB
Hi,
I would like to ask for assistance on how to connect to DocumentDB.
I have here sample URL:
mongodb://sample-user;:passwordSample-cluster.node.us-east-1.docdb.amazonaws.com:27017/sample-database?readPreference=secondaryPreferred&replicaSet=rs0
How to connect using the GetData options.
Please advise.
Thank you.
11 Replies
Please check the below link for steps.
https://www.progress.com/blogs/mongodb-odbc-driver-for-data-integration-with-power-bi
gilbertendayaHi Anonymous thank you for the response. I'm new on MongoDB.
Is this driver a freeware?
It is not, You have to download it from mongodb site.
Hopefully the below link will help.
https://docs.mongodb.com/bi-connector/master/reference/odbc-driver/
- gilbertendaya
amitchandak thank you for the links.
Is the BI connector from the URL that you sent, free for use?
I am sharing what I tried to get the documentdb data to powerbi. Configured the connection to documentdb using python and loaded one of collection as dataframe. From powerbi when you select GetData you have the option to configure python script, using that ran the python script and the dataframe was loaded to powerbi. Next you can transform data using power query as needed or I am assuming you could make the necessary changes in the python script itself and load the final dataframe.
Read the limitations of using python script:
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-python-scripts
Referred the below link for establishing connection to documentdb
https://stackoverflow.com/questions/64828294/python-ssh-tunnel-into-ec2-and-connect-to-documentdb
