Cannot add SQL SSMS to On-Prem Gateway

[awg201]

I have a report that uses a PBI semantic model and SQL query. All connections are direct query, hence the requirement to use on premeses gateway.

When I try adding the SQl connection to the gateway, I get the following error:

Unable to update connection credentials.
The on-premises data gateway's service account failed to impersonate the user.

Details:

CCQ_BIGW: Received error payload from gateway service with ID 131414: Error logging on username 'MYDOMAIN\username_here'..

Please have this information handy if you choose to create a support ticket.

Session Id: 6616bc07-026b-4068-9712-0ba4758b62e5
RequestId: 9a37fcff-f30e-4382-adf2-bf89729e4018
Cluster URI: https://api.powerbi.com
Status code: 400
Time: Fri Jun 27 2025 11:08:09 GMT+1000 (Australian Eastern Standard Time)

I usually connect to our SSMS via Windows Authentication SSO. Is there something I need to do to enable the GW to connect?

Thanks!

[Akash_Varuna]

Hi @awg201 It might be due to the incremental refresh policy overwriting the manually created partition during the model refresh. To retain the cold data partition while allowing incremental refresh, avoid manually creating partitions through XMLA after publishing. Instead, configure your incremental refresh policy to handle cold and recent data, or maintain archived data separately in your source system or a separate model.