How to connect to DocumentDB

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