Forum Discussion

Satyam916's avatar
Satyam916
New Member
3 years ago
Solved

Invalid Username and password for dataflow

Hi, Can you please tell how can I know the windows authentication username and pwd for dataflow creation? I have already installed and signed in to the dataflow.

 

I tried with the credentials which I used to login to my laptop but it is giving error :

 

Unable to create connection for the following reason: Invalid connection credentials.

Details: EntGateway: The credentials provided for the File source are invalid. (Source at c:\users\kiit\downloads\trainingdata1.xlsx.) Please have this information handy if you choose to create a support ticket. Session Id: 584cd3f2-1fc3-4969-b4e6-c4f7e3f4fa54 RequestId: ce8336af-c8e6-44be-bf97-8a13ed118aae Cluster URI: https://api.powerbi.com Status code: 400 Time: Wed Nov 01 2023 18:51:59 GMT+0530 (India Standard Time)Please have this information handy if you choose to create a support ticket. Session Id: 584cd3f2-1fc3-4969-b4e6-c4f7e3f4fa54 Cluster URI: https://api.powerbi.com Time: Wed Nov 01 2023 18:51:59 GMT+0530 (India Standard Time)
 
I also tried  using this command in cmd--
whoami /upn
ERROR: Unable to get User Principal Name (UPN) as the current logged-on user
is not a domain user.
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Satyam916 

    1.When you input the useraccount, you need to input the domain\username, you can open the cmd, and input 'whoami' to find your domain\username, then put it to the username and input the password.

    2.Your datasource is the local datasource, please make sure that you have installed the gateway. and make sure the gateway is installed on your own computer, the gateway should be installed on the same computer where your file is located. and the account you log in the gateway should be the same as the account you log in to the Power BI.

    3.Please make sure that the path of your file is right.

    If the following information cannot solve it, please consider to use sharepoint online or upload the file to onedrive.

     

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Satyam916 

    1.When you input the useraccount, you need to input the domain\username, you can open the cmd, and input 'whoami' to find your domain\username, then put it to the username and input the password.

    2.Your datasource is the local datasource, please make sure that you have installed the gateway. and make sure the gateway is installed on your own computer, the gateway should be installed on the same computer where your file is located. and the account you log in the gateway should be the same as the account you log in to the Power BI.

    3.Please make sure that the path of your file is right.

    If the following information cannot solve it, please consider to use sharepoint online or upload the file to onedrive.

     

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly