Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join 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.

Reply
Anonymous
Not applicable

Folder connection fails when using alternate credentials in Power Query

We're facing an issue with using a folder query on a network share. The network share in on a non-domain joined server, and we're using a local service account. Mapping the network folder in Windows works fine from both developer machines and the gateway server. Additionally, when connecting in Power BI Desktop using my (domain) credentials, connecting and refreshing works fine. However, when changing to alternate credentials and attempting to connect to the share, we get the following error:

Screenshot 2023-04-19 101257.png

 

Similarly, when attempting to use the connection on the gateway, we get the following error:

Screenshot 2023-04-19 101508.png

We saw initially that traffic was blocked on our network, but have since opened ports 139 and 445. Are there other ports that should be open? Any other steps that we may have missed? 

 

Regards,

Tore

1 REPLY 1
kadirkkkk2
New Member

If you're authenticate with a local user instead of domain user try creating a local user in your pc (or which the gateway is working on) with the same user name and user password of the file server user. It may solve your problem however it sounds crazy

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.