Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Ibrahim_shaik
Helper V
Helper V

Failing to Add Excel file to Standard data gateway

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.

2 ACCEPTED SOLUTIONS
v-nmadadi-msft
Community Support
Community Support

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

View solution in original post

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.

 

View solution in original post

4 REPLIES 4
Ibrahim_shaik
Helper V
Helper V

Hi @v-nmadadi-msft ,

 

Thank you for the response.

 

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

 

Thanks!

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.

 

Hi @v-nmadadi-msft ,

 

Issue got resolved, Thank you!

v-nmadadi-msft
Community Support
Community Support

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

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.