Forum Discussion

Dovi's avatar
Dovi
Regular Visitor
3 years ago

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

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] OD...
error: (400) Bad Request
Odata feed
Server Error
Dovi's avatar
Dovi
Regular Visitor
3 years ago

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.