Documentation

Credential authentication errors connecting Power BI to Customer Journey Analytics AEP

Last update: Thu Dec 18 2025 00:00:00 GMT+0000 (Coordinated Universal Time)

In Adobe Customer Journey Analytics, authentication errors occur when connecting Power BI to the BI Connector using a SQL client due to incorrect credential formatting or misconfigured permissions. To fix this issue, update credentials, assign correct permissions, and use the required username and password format

Description description

Environment

Adobe Customer Journey Analytics, Adobe Experience Platform

Issue/Symptoms

Attempts to connect Power BI to CJA via the BI Connector result in an error message: We couldn’t authenticate with the credentials provided. Please try again.

Resolution resolution

To fix this issue, follow these steps:

  1. In Adobe Experience Platform, go to Queries > Credentials, and select Generate Credential. For more information, see Generate credentials for Query Service.

    Note: The generated JSON file contains your credentials.

  2. Confirm that the new credential is visible in both the Experience Platform UI and Adobe IO Developer Console.

  3. In Admin Console, add the newly created API credential (usually the Adobe IO project name) to a product profile that has CJA BI Extension enabled and includes relevant data views.

  4. Assign the permissions for Manage Queries, Manage Query Service Integration, and data access to the role in AEP. The system automatically creates the role as ‘QueryServiceIntegration…’.

  5. In CJA, grant Product admin access to Customer Journey Analytics to view, edit, update, or delete connections and data views.

  6. Configure Power BI for AEP connection:

    • Open Power BI and select Get Data > PostgreSQL database from the connector list.
    • Enter the host as specified in your Experience Platform configuration.
    • Set the Database value to prod:cja?FLATTEN (using ?FLATTEN is recommended for compatibility).
    • Use DirectQuery mode for connectivity. For more information, see Connect Power BI to Query Service.

  7. For authentication:

    • Set Username as your IMS Org ID from the credentials page.
    • Set Password in the format technicalAccountId:credential (where technicalAccountId and credential are from your API credential JSON).

  8. Select desired tables and click Load.

  9. Verify that authentication succeeds and tables are accessible.

Note:

  • When generating credentials in AEP, a corresponding project is automatically created in Adobe IO projects, usually named like EQS-[ sandbox name] -OAuth.... You can also find it by searching for the ‘Technical Account ID’ as a filter.
  • Technical accounts cannot be added directly as users to user groups; manage permissions through API credentials assigned to product profiles.
  • The password must always use the format technicalAccountId:credential for non-expiring Query Service integration credentials.
  • If only a subset of tables appears after connection, confirm that all necessary data views are included in your product profile’s permissions.
  • If you have any issues, contact Adobe Customer Support for detailed assistance.
recommendation-more-help
3d58f420-19b5-47a0-a122-5c9dab55ec7f