Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Reply
Anonymous
Not applicable

On Premise Data Gateway and Local Computer User Permission Error?

Is anyone running a On Premise Data Gateway using one account to register/sign-in the OPDG software on the on-premise computer and a different account in the Gateway setup on Power BI .com ? I'm receiving an 'invalid credentials' error for credentials I know are good. After a few hours of reading I think they need to be the same account. I'd like to know for sure before I go down this road. 

5 REPLIES 5
Estela2
New Member

I am using AdventureWorks from SQL Server and according to the error the server side could not understand my request. I fixed the error by entering the user name from SQL Server in the username field as credential since the error states that a domain needs to be added. 

I hope this help.

 

Best whishes.

Estela1
New Member

I got the same error and I'm using AdventureWorks from SQL

Anonymous
Not applicable

@Anonymous ,

It doesn't matter  that you use different account to register on-premises gateway and sign in Power BI Service. As long as  you add the account you use to sign in Power BI Service as gateway administrator.

In your scenario, which data source do you add within the gateway? Please make sure that you are able to access the data source from gateway machine. You can install client in the gateway to test the connection.

Regards,
Lydia

Anonymous
Not applicable

Thank you for the suggestion. I added the account to the Gateway administrators. All of the connections are good if I use a different account. 

 

I am still receiving an error:

 

Unable to connect: We encountered an error while trying to connect to . Details: ""Hide details

Activity ID:ac671ff5-f78d-4df7-9290-222853872594
Request ID:e2262cc4-d0e1-7679-ff55-570e9274f06c
Cluster URI:https://wabi-us-north-central-redirect.analysis.windows.net
Status code:400
Error Code:DMTS_UpdateClusterDatasourceCredentialsErrorCode
Time:Mon Mar 04 2019 08:32:01 GMT-0600 (Central Standard Time)
Version:13.0.8482.156
xxxxxxxxxxxxxxxxxxxxxxx Data Gateway:Invalid connection credentials.
Anonymous
Not applicable

@Anonymous ,


What data source do you add within gateway?Could you please export gateway log following the guide in this article?

In addition, please make sure you are able to access the data source from the gateway machine using same connection string.

Regards,
Lydia

Helpful resources

Announcements
October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors