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

Resolution

1. Make sure you grant both access rights to the report user:
   • Data Warehouse OData Service - Navigate
   • OData - Access
2. Make sure the report user has access rights over the projects
3. Then run the jobs:
   
   • Load Data Warehouse
   • Load Data Warehouse Access Rights
   • Refresh Data Warehouse OData Model