Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin 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.
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.
Solved! Go to 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
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 ,
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 @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
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
32 | |
21 | |
20 | |
13 | |
12 |
User | Count |
---|---|
27 | |
18 | |
17 | |
17 | |
15 |