on permises gateway

2 Topics

Sage 100 On-Premises Gateway
Having trouble with a server-mounted, On-Premises Gateway communicating with my silent ODBC for Sage 100 access. On-Premises Gateway successfully installed on my server (also the Sage server), and my published Power BI semantic model recognizes it. The persistent error is that my DSN is incorrect. I've poured over community posts for the last couple weeks and believe I have my connection string and credentials correct, and ensured my ODBC is on the same machine as the Gateway. Error log: Matt_BCS: ODBC: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified The Gateway was originally installed on my machine and functioned well, refreshing on schedule. I'm attempting to migrate the Gateway off my PC so I don't accidentally close the nuisance Gateway window. Any ideas?
Solved
rbakins
2 years ago Place Report Server
1.4KViews
0likes
3Comments
On Permises Gateway credentials issue
Hi all, I am trying to set up an on-premises data gateway, however, stuck with the credentials issue. It all works fine with the personal gateway. When I am trying to add the data source (Located on the mapped network drive) to the gateway it's asking for windows credentials (Not sure why but .. ) after providing the credentials it throws an error. From the error, it seems that it can't access the file source from the mapped network drive. Also tried to use the same credentials as would use to map that drive and still the same error. Please advise. P.S. I am new to the Power BI
Solved
Zaibass81
5 years ago Place Report Server
1.8KViews
0likes
3Comments