Customer Journey Analytics BI extension connection issues with non-expiring credentials
When you create non-expiring credentials in Adobe Experience Platform, those credentials must have the correct Customer Journey Analytics (CJA) access and data view permissions to work with BI tools. If they don’t, you won’t see any CJA data views during connection. To fix this, you need to update the API credential permissions in Admin Console.
Description description
Environments
- Customer Journey Analytics
- Experience Platform (non-expiring credentials)
Issue/Symptoms
No CJA data views show when using non-expiring credentials to connect to BI tools such as Power BI or Tableau.
Resolution resolution
- Generate non-expiring credentials in Adobe Experience Platform. See Credentials guide: Generate credentials for details. After the credentials are created, download the JSON file that’s generated. It includes the
technicalAccountId,technicalAccountName, and thecredentialvalues. - In Admin Console, go to Users, then select API Credentials in the left navigation to view all generated API credentials.
- Find the correct credential by selecting the magnifying glass icon to open its details. Match the
technicalAccountNamefrom the JSON file with thetechnicalAccountIdshown in Admin Console to confirm you’re editing the correct credential. - Under Products, open the menu (three dots) for the credential and select Edit API credentials.
- Add the Customer Journey Analytics product and select the appropriate product profiles. The product profile must include the CJA BI Extension permission under Data View tools, along with access to the required Data Views.
- After you assign the correct permissions, the credentials are ready to use. When you authenticate with non-expiring credentials, enter the password as
technicalAccountId:credential. The username stays the same for both expiring and non-expiring credential types.
Related reading
- Adobe Admin Console documentation: https://helpx.adobe.com/enterprise/using/admin-console.html
- Customer Journey Analytics BI extension documentation: https://experienceleague.adobe.com/en/docs/analytics-platform/using/cja-dataviews/bi-extension
recommendation-more-help
3d58f420-19b5-47a0-a122-5c9dab55ec7f