Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

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



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,


Regular Visitor

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.
Regular Visitor

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

Impactful Individual
Impactful Individual

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.

Helpful resources

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.