Forum Discussion
Invalid connection credentials while adding data sources
Hi All,
I've installed and configured on-premise data gateway but when I try to adding data source (in this case an Excel file saved on my desktop) I get the below error details:
Johnmatta,
Do you install gateway in the same machine with your Excel file? Please make sure you enter correct user name and password when adding Excel data source, you can follow the guide in the similar thread below.
https://community.powerbi.com/t5/Integrations-with-Files-and/Scheduled-refresh-for-excel-file-with-on-premise-gateway/td-p/104363
Regards,
Lydia
8 Replies
Johnmatta,
Do you install gateway in the same machine with your Excel file? Please make sure you enter correct user name and password when adding Excel data source, you can follow the guide in the similar thread below.
https://community.powerbi.com/t5/Integrations-with-Files-and/Scheduled-refresh-for-excel-file-with-on-premise-gateway/td-p/104363
Regards,
Lydia- Thanks Lydia for your response.
Yes, I did install the gateway on the same machine that the Excel file is located.
I feel that the issue is in the username as the post you've attached refers to putting domain\username and my laptop is not on any domain.Hi Lydia,
I've found my domain\user and the datat source added successfully but when I tried to refresh the data I got the floowing message:
