Clarity and Power BI Report Refresh Error

Article Id: 195193

Status: Published

Updated On: 15-07-2020 13:09

Products:

Clarity PPM SaaS

Issue/Introduction:

One of our users is experiencing the following error when trying to open a Power BI report that she was able to open without a problem until recently. Other Project and Portfolio reports are fine.

Environment:

CLARITY SAAS APPLICATION

Resolution:

Check the reports are using one of the sources below. For example in the OData Feed window, enter the Data Warehouse OData End-Point URL (v2 or v4) that is noted from the Classic PPM System Options.

https://cppmbi9000.ondemand.ca.com/api/odata4/xxxxxxp/DataSourceV4
https://cppmbi9000.ondemand.ca.com/api/odata/xxxxxxp/DataSourceV2

In the report, after removing the second source to only using the one OData End-Point URL source, the connection works and user is able to refresh the data source to see the report tables and data.

For more information refer to Techdocs OData documentation: Connect to OData Using Microsoft Power BI Desktop