OData Error "Failure to Authenticate" when connecting with PowerBI

book

Article ID: 127825

calendar_today

Updated On:

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