ODBC Connection In Service - How To Save Username and Password

[danielpaduck]

Hi, 

I am using an ODBC connection for my Power BI Reports.  I set up the System DSN and confirmed it worked on the Gateway computer. I then set up the connection in the Tenant.  My reports work fine locally when I refresh and I use the system DSN (however, it first prompted my to enter a Username and Password).  However, after the report is deployed it fails refreshing.  I believe the main issue is that it does not know what the Username and Password is. I heard you can save these setting in the registry. But, can you can save them in the connection string?  Not sure how best to resolve this. 

Cheers! 

[GilbertQ · Accepted solution]

Hi @danielpaduck 

You should be saving your details as part of the connection name in the Power BI Service.

here is my blog post below where I show how to use the Athena ODBC Driver to get it working. Yours should be very similar on how to install, configure the ODBC Driver on your Gateway server and in the Power BI Service

Did you know you can query data from AWS S3 into Power BI? - FourMoo | Power BI | Data Analytics

[danielpaduck]

Awesome, I will check that out!