Hello all !
I am currently trying to connect to my local SQL Server (Our ERP) with the module Microsoft SQL Server.
I already did it for Power Bi Services thanks to On-Premises Data Gateway. It works well.
Is someone knows if it is possible to use the same DataGateway with Make to connect to my SQL Server ?
Because when I select the module Microsoft SQL Server (in a new scenario) when I create a new connection, I add the different points, (Host, Port, User, Password, Database) but I have errors (Connection Lost – read ECONNRESET, or time out after 15000ms)
I don’t really know where am I wrong or where I might be right.
And if there is an other solution than On-Premises Data Gateway feel free to let me know as well
Thanks you in advance
Nicolas