OData Error "Failure to Authenticate" when connecting with PowerBI

Article Id: 127825
Status: Published
Updated On: 21-02-2019 13:24
Products:
CLARITY PPM FOR ITG , Clarity PPM On Premise , CLARITY PPM FEDERAL , Clarity PPM SaaS , Clarity PPM SaaS - Application , Clarity PPM SaaS - Application , Clarity PPM On Premise
Issue/Introduction:

Trying to connect to OData with Power BI, we get the error message "Failure to authenticate".

Cause:

Missing permissions on the report user

Environment:

Release: CODFSS99000-15.5-PPM SAAS FedRAMP-Sandbox-Small Environment
Component:

Resolution:

Make sure you grant both access rights to the report user:
Data Warehouse OData Service - Navigate
OData - Access 

Make sure the report user has access rights over the projects.

Then run the jobs:

  1. Load Data Warehouse

  2. Load Data Warehouse Access Rights

  3. Refresh Data Warehouse OData Model