Forum Discussion
On Prem Gateway Invalid Credentials Excel File on Server
Ok so the next step is you need to make sure you have the correct gateway configuration. Check your project file and see what the list of data sources is. Its called "Data Source Settings" and can be found under the "Edit Queries". You need to make sure that each data source has an entry in your gateway. With the exception of cloud sources, every source has to be included for the data gateway to be valid.
Please make sure that you enter correct user name when adding Excel data source within gateway. The credential is same as that you use to sign in the computer. You can review the detailed steps in the following similar thread.
https://community.powerbi.com/t5/Integrations-with-Files-and/Scheduled-refresh-for-excel-file-with-on-premise-gateway/td-p/104363
Regards,
Lydia
Please make sure that you enter correct user name when adding Excel data source within gateway. The credential is same as that you use to sign in the computer. You can review the detailed steps in the following similar thread.
https://community.powerbi.com/t5/Integrations-with-Files-and/Scheduled-refresh-for-excel-file-with-on-premise-gateway/td-p/104363
Regards,
Lydia