Unable to connect Power BI With Clarity Odata

Products

• Clarity PPM SaaS

Issue/Introduction

We are trying to connect the Power BI with the Clarity Odata connector. However, are unable to use that.

The user we are using has the following access: 

Data Warehouse OData Service - Navigate

OData - Access

Along with that it is an Admin user account which has all other administrative privileges.

Environment

Release : 16.1.3

Cause

Users cannot access the data warehouse OData endpoints using their Clarity SaaS Portal login credentials or domain credentials in a federated SSO environment. 

Resolution

Create specific report users in Classic PPM: 

      a) 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.

     b)  Set up a password for these users in Classic PPM, so that they can use it for accessing the Data Warehouse OData Endpoints.

Additional Information

Note: Also please disable the option to "change the password on next login"