Forum Discussion

Ibrahim_shaik's avatar
1 year ago
Solved

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...
  • v-nmadadi-msft's avatar
    1 year ago

    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

  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    1 year ago

    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.