ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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
Powered by Wolken Software