OData Error "Failure to Authenticate" when connecting with PowerBI

Products

• Clarity PPM SaaS
• 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