Forum Discussion
Creating gateway connection name I am getting Invalid credentials for on premises data
Hi Team,
When I creating gateway connection for excel on premises data am getting invalid credentials like
Details: DataGateWay: The credentials provided for the File source are invalid. (Source at e:\ksr data vision\pai_international_storedata.xlsx.) Please have this information handy if you choose to create a support ticket. Session Id: 8b2fbb0d-4e29-41fc-99a8-17dd8e2331bc RequestId: 64e2ea57-a325-41e1-a090-66c596752222 Cluster URI: https://api.powerbi.com Status code: 400 Time: Sat May 24 2025 17:11:29 GMT+0530 (India Standard Time)
However i am entering windows user name and password is correct still i am getting this issue anyone help me sort out this.
Have you installed the gateway on the same machine where is file is hosted? or it was installed on a different windows machine?
If it was installed in a different widows machine, then make sure, your file is accessible to the machine where the gateway is installed. Also, in this case both the machines should be in same network and the file path you should enter in the file path should be relative network path.
If the gateway is installed on the same machine and you are still getting the incorrect password error then, please check whether you appended the domain name before user name or not, ideally it should be like
DOMAIN\UserNameNeed a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos.
Proud to be a Super User!
2 Replies
rohit1991Super User
Hi Suneel2429
The “invalid credentials” error usually happens because the gateway can’t access your file using a drive letter path like E:\.... In the Service you need to use the UNC path instead, for example \\ServerName\SharedFolder\file.xlsx. Make sure that folder is shared and that the Windows account you enter in the gateway has permission to read it.
Steps: open your PBIX in Desktop >> change the source to the UNC path >> republish. Then, in the Service, edit the gateway data source >> enter the same UNC path >> choose Windows authentication >> type DOMAIN\username with the correct password. If the gateway is on the same machine as the file, you still must use the UNC path. Once both sides (Desktop and Service) match and permissions are set, the connection should work.
- tharunkumarRTK
Have you installed the gateway on the same machine where is file is hosted? or it was installed on a different windows machine?
If it was installed in a different widows machine, then make sure, your file is accessible to the machine where the gateway is installed. Also, in this case both the machines should be in same network and the file path you should enter in the file path should be relative network path.
If the gateway is installed on the same machine and you are still getting the incorrect password error then, please check whether you appended the domain name before user name or not, ideally it should be like
DOMAIN\UserNameNeed a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos.
Proud to be a Super User!