topic Re: Odata - failed to connect to data source - Remote server returned an error : (400) in Report Server

Odata - failed to connect to data source - Remote server returned an error : (400)

Dovi — Sat, 04 Feb 2023 16:36:02 GMT

Hi,

Trying to connect Clarity PPM data warehouse using Odata but get this error message:

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] OData: Request failed: The remote server returned an error: (400) Bad Request. ([HYT00][0] Login has timed out.). '.

The weird things is that I am able to conncet to a different environment with no issues.

Please advise how to solve this,

Dovi

Re: Odata - failed to connect to data source - Remote server returned an error : (400)

jaweher899 — Mon, 06 Feb 2023 08:39:35 GMT

This error message is indicating that the connection to the Clarity PPM data warehouse using OData has failed due to a Bad Request error with a message indicating a login timeout.

Here are some steps you can try to resolve this issue:

Check the credentials you are using to connect to the Clarity PPM data warehouse. Make sure they are correct and still valid.
Check the network connection to the Clarity PPM data warehouse and make sure it's stable and not being blocked by any firewalls or security systems.
Try to connect to the Clarity PPM data warehouse using a different tool or program to see if the issue is specific to PowerBI or if it's a problem with the data warehouse itself.
If you are still unable to resolve the issue, reach out to the support team for Clarity PPM or your IT department for further assistance.

I hope these steps help you resolve the issue.

Re: Odata - failed to connect to data source - Remote server returned an error : (400)

Dovi — Mon, 06 Feb 2023 09:56:13 GMT

jaweher899 - Thank you so much! Will try all of the above steps!

Re: Odata - failed to connect to data source - Remote server returned an error : (400)

Dovi — Wed, 22 Feb 2023 14:14:53 GMT

After performing following steps I was able to solve the issue:

Clear the Power BI Cache:
1. Click on File
2. Options and Settings
3. Click on Options
4. "Clear Cache" for Data Cache Management Options"
5. "Clear Cache" Q&A Cache Options
Run the Full Load of DWH Job
Run the Load DWH Access Rights Job
Run Odata Refresh Model Job
Close and re-launch Power BI and test the connection.