Odata Connection not Supported with Power Bi Server
Article ID: 98141
Updated On:
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: someSource).”
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.
“OData: Request failed: The remote server returned an error: (500) Internal Server Error. (An error has occurred while accessing the data source: someSource).”
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.
Resolution
The use of PowerBI Server or PowerBI builder to publish reports is not supported. 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.
Feedback
Yes
No
Powered by
