Algeria Power BI User Group

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Difficulty - I cannot connect the gateway to excel file

  • 1.  Difficulty - I cannot connect the gateway to excel file

    Gold Contributor
    Posted Jun 30, 2021 04:51 PM
    Hi All,

    I have this issue for long time.

    I am able to connect the gateway installed on my machine to sql server instance but it is not for any particular file (Excel or txt file). it gives me error all time .

    I keep restarting the gateway, my username/password are correct , and it is working for sql connection.

    Please let me know if you experience the same issue and/or you were able to fix it.

    Thank you so much.

    Said

    ------------------------------
    S B
    Data Manager
    ------------------------------


  • 2.  RE: Difficulty - I cannot connect the gateway to excel file

    Top Contributor
    Posted Jul 05, 2021 09:13 AM
    Edited by Mehdi HAMMADI Jul 05, 2021 11:30 AM
    Hi said,
    It seams that you are not the only one getting this type of error.
    I found a discussion on the "Power BI Community" site and other people are facing the same issue.
    Maybe you can join them or follow up the discussion to get provide and get back more details. On-premise Gateway - cannot connect to Excel file - Microsoft Power BI Community

    I also found this article from @Chris Webb that maybe can help : Chris Webb's BI Blog: Configuring Power BI Gateway Data Sources For Files And Folders Chris Webb's BI Blog (crossjoin.co.uk)

    ------------------------------
    If any discussion or answer help, please mark it as "Recommend"
    ------------------------------

    Best regards
    Mehdi HAMMADI

    MCT | MCSA BI Reporting | MCSE Data Management and Analytics | Data Analyst Associate
    2019 Ruby Award Dynamic Communities
    ------------------------------



  • 3.  RE: Difficulty - I cannot connect the gateway to excel file

    Gold Contributor
    Posted Jul 05, 2021 09:22 PM
    Thank you so much.

    I am still looking for help and assistance.

    ------------------------------
    S B
    Data Manager
    ------------------------------