PowerBI ODBC automatic login

[handelbiz1]

Dear community,

we want to import data from data base via ODBC. Unfortunately, I get asked for the username and password for the data source. Can we define credentials somewhere so that every user of this computer or this database will never be asked for credentials (Also during the initial/first connection). The credentials are already saved in the ODBC settings in Windows.

Thank you!

[v-luwang-msft]

Hi @handelbiz1 ，

Similar question pls refer :

https://community.powerbi.com/t5/Desktop/Automatically-Connecting-to-ODBC/m-p/631383 

Best Regards

Lucien

[handelbiz1]

Thank you. Unfortunately gateway etc. in not an option in our company. I meant for example automatically deploy data source file (PBDIS)