Forum Discussion

ellde39p's avatar
ellde39p
Frequent Visitor
10 years ago

Error when loading CRM data into Power BI

I receive an error when I try to either:

1. Apply Query changes or

2. Load Microsoft CRM 2015 data

 

"Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error:[DataSource.NotFound] OData: Request failed (404): The remote server returned an error: (404) Not Found.. OLE DB or ODBC error:[DataSource.NotFound] OData: Request failed (404):"

 

This error does not occur when I choose the 'Edit' option (instead of the 'Load' option) when selecting a CRM table/view. ie. the table successfully loads into Power BI and I can manipulate fields etc.  This would indicate that it is not an issue with the OData connection but perhaps something else?

8 Replies

  • ianbarker's avatar
    ianbarker
    Helper III
    10 years ago

    Hi ellde39p

     

    I've seen this error too when "applying" the queries.

    What steps have you added to your query(s)?

    • ellde39p's avatar
      ellde39p
      Frequent Visitor
      10 years ago

      Hi Ian,

       

      My only step is to navigate to the table.  If I take out this navigation step, the message "There are pending changes in your queries that haven't been applied" goes away.  I want to be able to load the table (it only has 18 records in the table).

       

      Regards,

      Derek

      • ianbarker's avatar
        ianbarker
        Helper III
        10 years ago

        Hey Derek,

         

        That's correct, you don't want to remove the navigation step. I just wasn't sure if you had any additional steps, such as merges that may be causing the issue, but that doesn't sound like the case.

         

        I have one more suggestion. Click on File > Options and Settings > Data Source Settings.

        You will then hopefully see a single data source for your CRM instance.

        Double click on this and a screen will open. In this screen there should be an option to specify your your login details. It's possible that even though you've already logged in at some point, your details aren't being asscoiated with your data source. There will be an option to edit or enter your login details for CRM. Obviously make sure you are using a login that has appropriate permissions in CRM.

         

        Regards,

        Ian