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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

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
Regular Visitor

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
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.