Forum Discussion

mpros's avatar
mpros
Icon for Helper I rankHelper I
1 year ago
Solved

PBI 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...
Need Help
  • v-venuppu's avatar
    v-venuppu
    1 year ago

    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.

     

  • mpros's avatar
    mpros
    Icon for Helper I rankHelper I
    1 year ago

    Dear GilbertQ 
    as mentioned in the message, I was able to connect through ODBC, but I need SMB as the data I need to work on is there:

    • ODBC (Open Database Connectivity): This is an interface for accessing structured data (e.g., DB2 tables on AS/400), not system files. It's used for SQL queries, not for browsing folders or files.
    • SMB (Server Message Block): This is a file-sharing protocol used by Windows to access shared folders on other systems.

    Regards,
    M