The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
I am trying to map ODBC datasource shown below to a newly setup Enterprise Gateway.
I have successfully setup this datasource on the Gateway (see image below) . But this is not recognized by the Gateway Connection dialog shown above.
I suspect this is due to escape characters "\" introduced in filepath under Gateway connection dialog. Also entire connection string is converted to lower case, and does not match actual connection string used in the gateway as shown below. Note upper case in driver name, and fil property in the actual connection string below.
dbq=\\ncxxxxxx\shared\quant\sxxxxxxx xxxxxx\reporting\database\daart\daart.accdb;driver={Microsoft Access Driver (*.mdb, *.accdb)};driverid=25;fil=MS Access;max buffersize=2048;pagetimeout=5
Will appreciate any help to map this datasource in the gateway
I have tried using a dsn but i get an invalid username or password error
@Anonymous
Dont configure directly in Gateway. Please remove it and try to navigate to Dataset settings and Gateway Connection, From here you can click on "Add to Gateway" and configure to the Gateway.
Note:- Use same credentials in Desktop and Service.
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
In case it does not help, please provide additional information and mark me with @
BR
venal.