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

[Dovi]

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

[Dovi]

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

1. 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
2. Run the Full Load of DWH Job
3. Run the Load DWH Access Rights Job
4. Run Odata Refresh Model Job
5. Close and re-launch Power BI and test the connection.

[Dovi]

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

[jaweher899]

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:

1. Check the credentials you are using to connect to the Clarity PPM data warehouse. Make sure they are correct and still valid.

2. 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.

3. 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.

4. 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.