Odata Connection not Supported with Power Bi Server

Products

• Clarity PPM SaaS

Issue/Introduction

When attempting to connect to ODATA using Power BI Server, the following error is noted:

“OData: Request failed: The remote server returned an error: (500) Internal Server Error. (An error has occurred while accessing the data source: CA34001PDataSource).”

Upon further investigation we have figured out that we cannot test the connection from within Power BI Server portal either. The error we receive there is:
“Log on failed. Ensure the user name and password are correct.”

The correct user name and password is being used, and same username and password works fine on the Power BI Desktop environment.

Environment

CA PPM 15.9.1 (SAAS)

Resolution

Unfortunately currently CA does not support the use of PowerBI Server or PowerBI builder to publish reports.  We only support Excel, PowerBI Desktop, and Tableau for accessing data using the ODATA connection.

Additional Information

With OData the Data Warehouse schema and data are open for consumption to external reporting tools. The Saas team exposes the OData feed using the OData v2 or v4 endpoint URLs for consumption and the Clarity report users can configure their BI tool with the URL and OData authentication string. Brodcom Techdocs provides steps on setup to get the OData connected with Tableau Desktop however the setup/using Tableau server in out of scope.