Follow https://docs.mongodb.com/bi-connector/current/connect/powerbi. When setting up the ODBC Connector in window it is important to select the database otherwise PowerBI is not able to handle it.
I had to restart the containers to see the my test DB appear in PowerBI.
It is possible to connect to the the BI Connector using the MySQL connector as well. This simplifies the setup quite a bit. Simply point the connection to the BI Connector address
- http://localhost:3307: BI Connector
- http://localhost:8081: mongo-express (UI to work with the DB)
Be sure docker is installed and running and execute docker-compose up or docker-compose start in this folder.
- Ryanhs for the container and the initial docker compose file https://github.com/ryanhs/mongodb-bi-connector-docker