Clarity Power BI Odata Source Refresh Failure

book

Article ID: 198221

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

Post GCP migration I repeatedly get the error below when trying to refresh the Clarity data source from Power BI.

Something went wrong
There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.
Data source error: {"error":{"code":"ModelRefresh_ShortMessage_ProcessingError","pbi.error":{"code":"ModelRefresh_ShortMessage_ProcessingError","parameters":{},"details":[{"code":"Message","detail":{"type":1,"value":"OData: Request failed: The remote server returned an error: (400) Bad Request. ([42501][0] [DD Cloud OP][PostgreSQL JDBC Driver][PostgreSQL]permission denied for view dwh_inv_assign_per_facts_w_v. )"}}],"exceptionCulprit":1}}} Table: DWH_INV_ASSIGN_PER_FACTS_W_V.
Cluster URI: WABI-US-NORTH-CENTRAL-B-redirect.analysis.windows.net
Activity ID: 35bd571c-7c68-4bcc-8997-e18a9a9f718b
Request ID: 53496dd9-18a4-69e4-1071-b81dbe1cd61f
Time: 2020-08-25 13:33:03Z

Environment

CLARITY SAAS APPLICATION

Resolution

This is related to a permissions issue as per in the error we see "permission denied for view dwh_inv_assign_per_facts_w_v". To resolve permissions issue run the Clarity jobs below individually, in the following sequence to ensure the jobs create and update permissions and synonyms for OData objects that are in the data warehouse.

Go to Clarity > Home > Reports and Jobs > Jobs

1) Load Data Warehouse
2) Load Data Warehouse Access Rights
3) Refresh Data Warehouse OData Model

Refresh the OData Endpoints