Clarity and Power BI Report Refresh Error

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