Forum Discussion
On-Premises Gateway - ODBC data source error
Hello everyone,
I am having a hard time setting up the On-Premise Gateway for manual refreshes. Here's my setup:
MariaDB
ODBC Connector (64bit)
Power BI (64bit)
On-Premise Gateway (64bit)
In the Manage Gateways menu it says: "Online: You are good to go". When I try to add data sources to use the gateway I run into the following error:
Can someone please guide me on how can I get this working? I would really like to be able to refresh the data. I have tried everything and I can't seem to get it up and running.
Thank you so much,
Cosmin
LE: I've noticed that there is a typo in the screenshot. It doesn't work with DSN either.
10 Replies
Hello,
Have you tested the ODBC driver on the machine the gateway is on through control panel ?
Dyer
Sure. It works without a problem.
Thanks,
Cosmin
Could you confirm that your enterprise gateway is based on the same server where the ODBC is set up.
I've also noticed that the ODBC is a User DSN and it may not be visible for the gateway, try to create a System DSN instead.
Hello Eric,
Thank you so much for the solution. It seems that the System DSN fixed part of the problem. The connection is now succesful but I am unable to refresh the dataset. It says that the credential stored in the cloud is missing. ???
Can you please help me with this?
Works with System DSNUnable to refreshCredentials not stored in the cloud
Thank you,
Cosmin
Kind reminder.
