Forum Discussion
mpros
Helper I
Helper IPBI Service: AS400 Server with folder connector doesn't work with SMB
I have an AS400 server, whose database is accessible through ODBC. But I need to access it through SMB. Credentials are working both in CMD and PBI Desktop, but not in PBI Service throwing wrong cre...
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.
