Forum Discussion

e_kalonji's avatar
e_kalonji
Frequent Visitor
1 year ago
Solved

Gateway Connection on Power BI Service.

Hi Guys,
Althought I have successfully created a gateway and provided the file's path in order to load the data into the dataflow of power bi service, am getting this error message. My login details are correctly entered, would you assist me in this regard?

Kindly

Dataflow
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Thanks for the replies from SaiTejaTalasila and rajendraongole1.

     

     Hi e_kalonji ,

     

    Based on the error message you provided, I observed that the path you are using seems to be a folder, can you copy the complete file name of the csv or text file and try again. Please right click on the file and copy as path.

    This is my test result:

     

    Best Regards,

    Zhu

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.

8 Replies

  • rajendraongole1's avatar
    rajendraongole1
    Super User
    1 year ago

    Hi e_kalonji - can you double check the path format:

    e.g., \\ServerName\SharedFolder\FileName.xlsx), as Power BI may not recognize mapped drives (like Z:\FileName.xlsx).

     

    Hope  you checked the user account configured for the gateway has read access to the file location.In the Connection Credentials section, check that the correct authentication method is selected. For example, use Windows Authentication if the file is in a secured network location that requires domain credentials.

     

    if above details looks ok, cross check and re-registering the gateway in the Power BI Service. Sometimes re-adding the data source can resolve connectivity issues.

     

    • e_kalonji's avatar
      e_kalonji
      Frequent Visitor
      1 year ago

      Hi rajendraongole1!

      Thank you for you prompt reply. I have indeed double-checked the file's path as you have suggested, as a matter of fact, I did it before and after you had suggested.

       

      I even ran the "whoami" command in the command shell to try using my local pc rather than my email, and when I did that, the error message changed as per above photo.

      It was mentionned in the tutorial am busy with that this stage is a bit tricky, I saw however the lecturer connecting using his email address in the authentication section. Though I faithfully followed the steps and even explored ather options, I still cannot connect.

      • rajendraongole1's avatar
        rajendraongole1
        Super User
        1 year ago

        Hi e_kalonji -When configuring the data source in the On-premises Data Gateway (in Power BI Service), ensure the Data Source Credentials match the account with file access. Often, it's helpful to use a domain\username format if the account is on a domain.
        If your email isn’t working, try logging in with domain credentials directly in the gateway configuration (e.g., DOMAIN\username) instead of the email format.

        If you’re still unable to connect, a good approach would be to test with a simple data source, like a local Excel file, to isolate whether the issue is specific to the network drive configuration.

        ref link:

        Troubleshoot gateways - Power BI | Microsoft Learn

        View and manage on-premises data gateways - Power Platform | Microsoft Learn

         

        Hope this helps.