Forum Discussion

gerard-kouadio's avatar
1 year ago
Solved

Power BI Gateway for HFSQL

  • Hi gerard-kouadio ,

    Try these troubleshooting options.

    Verify Your ODBC DSN Configuration
           First, ensure you have a properly configured ODBC Data Source Name (DSN) on the gateway machine:

           Connection String Format for HFSQL
    The correct ODBC connection string for HFSQL

    Configure the Gateway Data Source

    Under "Gateway connection", ensure:
    —>The correct gateway is selected
    —>The data source matches what you configured
    —>Credentials are properly set (use "Edit credentials")

    32-bit vs 64-bit - Ensure your ODBC DSN matches the gateway architecture (typically 64-bit).

     

    If my response solved your query, please mark it as the Accepted solution to help others find it easily.

    And if my answer was helpful, I'd really appreciate a 'Kudos'.

5 Replies

  • Recommend to shorten the dsn - there is a string size limit of 32 characters.

  • V-yubandi-msft's avatar
    V-yubandi-msft
    Community Support

    Hi gerard-kouadio ,

    Try these troubleshooting options.

    Verify Your ODBC DSN Configuration
           First, ensure you have a properly configured ODBC Data Source Name (DSN) on the gateway machine:

           Connection String Format for HFSQL
    The correct ODBC connection string for HFSQL

    Configure the Gateway Data Source

    Under "Gateway connection", ensure:
    —>The correct gateway is selected
    —>The data source matches what you configured
    —>Credentials are properly set (use "Edit credentials")

    32-bit vs 64-bit - Ensure your ODBC DSN matches the gateway architecture (typically 64-bit).

     

    If my response solved your query, please mark it as the Accepted solution to help others find it easily.

    And if my answer was helpful, I'd really appreciate a 'Kudos'.

  • V-yubandi-msft's avatar
    V-yubandi-msft
    Community Support

    Hi gerard-kouadio ,

    May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

    Thank you.

  • V-yubandi-msft's avatar
    V-yubandi-msft
    Community Support

    Hi gerard-kouadio ,

    Has your issue been resolved, or do you require any further information? Your feedback is valuable to us. If the solution was effective, please mark it as 'Accepted Solution' to assist other community members experiencing the same issue.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi @gerard-kouadio ,

    Has your issue been resolved, or do you require any further information? Your feedback is valuable to us. If the solution was effective, please mark it as 'Accepted Solution' to assist other community members experiencing the same issue.

     

    Regards,

    B Manikanteswara Reddy