Clarity Power BI Odata Source Refresh Failure
Article ID: 198221
Updated On:
Products
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: <URI>
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
Feedback
