Sage 100

Have a client working with Power BI. They used it on their previous version (2014) and are attempting to get it to work with 2017 again. They have always used the 64 bit driver. HOWEVER, the 64-bit driver now isn't auto-connecting. We have it setup with the company code and a user and password and the connection (not the SOTAMAS90 connection, a new one) tests fine. However, when they attempt to connect from Power BI, it prompts for the login again. Has anyone seen anything similar? Oh, WAIT - no it was NOT working with the older version. OK, so let's just concentrate on the fact that it keeps prompting now.

The credentials are now stored (thanks to @ClarkWalliser for finding them)

And @ClarkWalliser for finding them first... :-)

OMG, thank you @DanBurleson !!!!!

To automate the ODBC login process in Power Query and Power BI, go to Data Source Settings, select the data source you want to modify, and edit credentials. On some versions of Excel the edit credentials is a separate dialog item from credentials. On others the edit credentials is within the edit permissions. Edit the Database credentials. The user ID , then a pipe symbol | and the company ID, ie.""ABC"". The user password appears to be encrypted, but I'm not certain of that. Also note that there are both global and file specific data sources.