ODBC. Query connector- Provide username password in connection string

[kevalkakadiya]

Is there a way we can specify username and password along with entire connection string while connecting to a database in mquery?

If yes, I could not find the valid syntax anywhere on the internet not even in the official documentation.

Thanks

[kevalkakadiya]

Hey buddy. Thanks for the reply. Appreciate it. 

But these links are not related to poewr bi. I know how it works in qlikview and how we can include username and password in connection string. 

Maybe, I was unclear the first time I asked the question but I want to know the syntax that we add in power BI mQuery Advanced editor that can include username and password.

I did come across a similar post on the forum but I did not find a solution.

Solved: Enterprise Gateway with ODBC - Microsoft Power BI Community

[v-yanjiang-msft]

Hi @kevalkakadiya ,

Please refer to the solution in the similar problem: 

Solved: ODBC Connection String with Username & Password - Qlik Community - 193060

r - RODBC - connection string add username and password - Stack Overflow

Best Regards,
Community Support Team _ kalyj

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