ODBC connection by gateway error

Hi,MattiaFratello ,thanks for your concern about this issue.

Your answer is excellent!
And I would like to share some additional solutions below.
Hello,Syndicate_Admin .I am glad to help you.
When you configure a gateway connection, you need to set up credentials for the gateway connection to be able to access your data source properly.
You need to ensure that the user roles you set up can access your data source properly.
Which authentication method you should use depends on your data source type.
URL:
Solved: Adding ODBC datasource to gateway - Microsoft Fabric Community
Solved: PowerBI Gateway - specific ODBC setting on gateway - Microsoft Fabric Community
 
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian