Gateway Connection on Power BI Service.

[e_kalonji]

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

[e_kalonji]

Thank you @v-linhuizh-msft, worked like a charm!

[rajendraongole1]

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]

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.

[SaiTejaTalasila]

Hi @e_kalonji ,

You can try this in your folder names, file names replace spaces with _ and see whether the same issue occurs or not.

I hope it will be helpful.

Thanks,

Sai Teja 

[e_kalonji]

Thank you @SaiTejaTalasila for your your help. Indeed I replace the name of the file with a underscore (_) as you suggested, still did not work.

Kindly

[rajendraongole1]

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. 

[e_kalonji]

Hi @rajendraongole1, there is no way to set a gateway using the local computer's login details since the system requires an email address.

I read all the resources you recommended, double checked that my login details corresponded, but am still getting this two error messages:

1. This one when am using my email address.

2. This one when I attempt to connect using my local machine login details.

[v-linhuizh-msft · Accepted solution]

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.