Hello @Allan_Brett I will try to assist you. If you are receiving the error as the original poster was, this is indicative of a timeout which stems from an issue with one or more of the following: 1. Login Credentials are incorrect or lacking in permissions, 2. IP Whitelisting/access or Network traffic blocks (firewall or VPN rules on your end), or a malformed/incorrect connection string.
Since the Atlas SQL interface needs connection to Atlas Data Federation, we need the make sure the Compass connection to the Federated DB Instance works as that will remove all of the added variables that the Power BI connection imposes. In most cases (I think 95%), when a user gets this error in Power BI, it becomes resolved, once we can successfully connect from Compass (of course as you mentioned, from the same machine, using the same log in credentials, and the URI for the Federated DB Instance). If you’d like to email me a screen shot of your compass connections (removing the password from view) - I might be able to direct you further.
here is my email address: Alexi.antonino@mongodb.com
Best,
Alexi