Enterprise Gateway refresh error to on-premise SQL Server

[mondinelli]

I've correctly configured a enterprise gateway:

[12_shashank]

I’ve encountered a similar issue with the same error. The solution is to grant the necessary permissions to the service principal or the user accessing the API (ReadAll or User permission), for the connections, and On-premises gateway. You can do this in Fabric or POWER BI service settings > Manage Connections and Gateways > Connections/ On-premise Gateways. 

Error Encounter - 

DMTS_CanNotFindMatchingDatasourceInGatewayError

[mondinelli · Accepted solution]

the Tech Staff told me that 400 error was about a PowerBIErrorCode: DMTS_CanNotFindMatchingDatasourceInGatewayError.

The enterprise gateway was not able to find all datasource, even if on the first check it was.

Solutions is to manually check all the datasource of the report and all the datasource on the enterprise gateway.

[pritesho]

Try removing and readd.  There could be code mistype or something causing it. It has smoothly worked for me for a few times, so it could be a simple issue of refresh.

[mondinelli]

There was a problem on post saving, i've added several images but they seems to be stripped out. I'll retry here. if it's all there will be here 3 images.

Connection Testing FineGateway Selection okError Throwed

I can't figure out why i get status code 400, whatever it means.

I've tried to reinstall gateways several times.