Forum Discussion
Invalid connection credentials while adding data sources
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
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:
Johnmatta,
Please post the data source setting(File->Options and settings->data source setting ) in Power BI Desktop and share a screenshot about the data source you added within your gateway. Please do mask sensitive data before you upload screenshots.
Regards,
Lydia- Sorry Lydia, I figured it out now. The windows username was AzureAD\my user name and I had to choose the gateway under dataset settings...thanks so muck for your help.
