Forum Discussion
Helper IPBI Service: AS400 Server with folder connector doesn't work with SMB
Hi mpros ,
Even though credentials work in Power BI Desktop,Power BI Service fails because it runs in the cloud and relies on the On-Premises Data Gateway to access SMB shares.
To fix this:
As you already Installed the Gateway on a machine that can access the AS400 shared folder.Run the Gateway Service under a Windows account that has access to the SMB share (not the default system account).Configure the data source in Power BI Service using the UNC path (\\AS400Server\SharedFolder) and matching credentials.Test access from the gateway machine using net use to confirm connectivity.
This ensures Power BI Service can authenticate and access the AS400 folder via the gateway.Thank you.
Helper IDear v-venuppu ,
That's exacly what I did, but when I try to enter same credential in PBI Service it throws an error. Is just with the service the problem. Meanwhile I produced a Powershell Script to move flat files in a Windows Server and using Folder Connect on that destination, but would like to query directly the AS400 one.
Regards,
Marco
Community SupportHi mpros ,
Even though credentials work in Power BI Desktop,Power BI Service fails because it runs in the cloud and relies on the On-Premises Data Gateway to access SMB shares.
To fix this:
As you already Installed the Gateway on a machine that can access the AS400 shared folder.Run the Gateway Service under a Windows account that has access to the SMB share (not the default system account).Configure the data source in Power BI Service using the UNC path (\\AS400Server\SharedFolder) and matching credentials.Test access from the gateway machine using net use to confirm connectivity.
This ensures Power BI Service can authenticate and access the AS400 folder via the gateway.
Thank you.