Failing to Add Excel file to Standard data gateway

[Ibrahim_shaik]

Hello Power BI Community,

I have a report connected to sql database in cloud and three excel files in local server.

I have configured standard data gateway and i need the data to auto refresh, I configured the gateway and it's online and I have mapped the report to the gateway connection as i have three excel files as well that i am trying to add, which are in my server to add these three files to the gateway i need to create a connection and in that I have entered the device admin credentials but i get an Error as Unable to create connection "Invalid Connection credentials"

Details: The credentials provided for the file source are invalid(source at ........)

status code: 400

Please suggest a solution to fix this issue.

Thanks & Regards,

Ibrahim.

[v-nmadadi-msft · Accepted solution]

Hi  @Ibrahim_shaik,
Thanks for reaching out to the Microsoft fabric community forum.

Ensure that the file path provided in the connection settings is accurate and accessible from the machine where the gateway is installed. To verify this, try manually accessing the file using the same path and credentials from the gateway machine. This will help confirm whether the issue is related to incorrect file path configuration or insufficient access permissions.

Also Verify if the credentials you are using are correct and have the necessary read permissions. Ensure that you are using the appropriate Windows credentials, including the correct username and password. Additionally, try entering the credentials in the format "domain\username" instead of just the username to avoid authentication issues.

If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thanks and Regards

[Ibrahim_shaik]

Hi @v-nmadadi-msft ,

Thank you for the response.

Sure, I will try this and will let you know.

Thanks!

[v-nmadadi-msft · Accepted solution]

Hi @Ibrahim_shaik,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[Ibrahim_shaik]

Hi @v-nmadadi-msft ,

Issue got resolved, Thank you!

[v-nmadadi-msft · Accepted solution]

Hi  @Ibrahim_shaik,
Thanks for reaching out to the Microsoft fabric community forum.

Ensure that the file path provided in the connection settings is accurate and accessible from the machine where the gateway is installed. To verify this, try manually accessing the file using the same path and credentials from the gateway machine. This will help confirm whether the issue is related to incorrect file path configuration or insufficient access permissions.

Also Verify if the credentials you are using are correct and have the necessary read permissions. Ensure that you are using the appropriate Windows credentials, including the correct username and password. Additionally, try entering the credentials in the format "domain\username" instead of just the username to avoid authentication issues.

If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thanks and Regards