Power Bi connect to AWS DocumentDB Driver in the AWS Remote Desktop

[mithunvirstack]

We are Evaluating the Power BI:

Trying to connect power BI (Version: 2.124.1052.0 64-bit (December 2023) with DocumentDb Driver 1.0.0. while setup the DNS im getting this ERROR: 

Connection failed: 'failed to establish connection with host. INvalid username or password or user is not authorized on database `sampleDb`. Please check your settings. Authorization failed to user `useName` on database `admin` with mechanism `SCRAM-SHA-1`. please check username password, database and authorization for the user

I got this in the ODBC Data source 64Bit DNS configuration. But when i tring to connect through the mongo DB compass to the Document cluster its working fine. How can solve this?

[mithunvirstack]

Hi, Our DB name is "products" and we have not a database called admin. 

[v-junyant-msft]

Hi @mithunvirstack ,

Please Double-check the username and password you are using to connect to DocumentDB. Ensure there are no typos or incorrect case usage, as these credentials are case-sensitive.
And confirm that the user 'useName' has the necessary permissions on the 'sampleDb' database and the 'admin' database. Ensure that the user is authorized to connect from the host where Power BI is running.

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.