CA PPM SAAS OData connection is failing with message 'We couldn't authenticate with the credentials provided. Please try again."

Document ID : KB000120687
Last Modified Date : 09/11/2018
Show Technical Document Details
Issue:
After upgrading CA PPM SAAS environment to 15.5, we are no longer able to authenticate OData Feed in Power BI and receiving an error message 'We couldn't authenticate with the credentials provided. Please try again." 


 
Environment:
CA PPM SAAS ODATA
Resolution:
This is working as designed as the supported procedure is to use a CA PPM SAAS non-portal user only.

https://docops.ca.com/ca-ppm-saas/15-5/en/administration/configure-the-data-warehouse-and-advanced-reporting/configure-odata-access-to-the-data-warehouse#ConfigureODataAccesstotheDataWarehouse-AccessODataEndpointsUsingCAPPMCredentials
Additional Information:

Note: Users cannot access the Data Warehouse OData endpoints using their OD Portal login credentials or domain credentials in a Federated SSO environment. To allow access to the Data Warehouse OData Endpoint URL in these environments, complete the following steps:

  1. Create specific report users in CA PPM SaaS.
    You can re-use existing product users provided they do not have the External Authentication option checked in the resource properties under Administration. If the option is checked, create new report users.
  2. Set up a password for these users in CA PPM SaaS so that they can use it for accessing the Data Warehouse OData Endpoints.