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...
ianbarker's avatar
ianbarker
Helper III
10 years ago

My only other suggestion would be to try doing the same thing from another machine to see if it makes a difference.

I'm not sure if doing it from a VM is an option for you?

 

Other than that, I'd click the frown button and send the details to Microsoft.

As I mentioned, I've hit the same issue myself with CRM and never really got to the bottom of it.

ellde39p's avatar
ellde39p
Frequent Visitor
10 years ago

Thanks Ian,

 

I have tried on my boss's PC with BI installed and received the same errors.

 

Sorry to ask but where do I find the 'Frown' icon to click?  (this is my first post)

 

Regards,

Derek

  • ianbarker's avatar
    ianbarker
    Helper III
    10 years ago

    Bummer. I know how frustrating it can be.

     

    Top left hand corner of the screen there's a little smily face. If you click on it, a drop-down appears and there's a sad face which says "Send a Frown".

    When you click on it, it will generate an email for you with a load of data related to your PBIX file.

    You can also add additional screenshots and supporting info.

    • ellde39p's avatar
      ellde39p
      Frequent Visitor
      10 years ago

      According to our software supplier... 

      The Rest API is not available in CRM 2015 Online and so this option may not be available until we upgrade to CRM 2016.
       
      As this appears to be an MS bug there is not a lot I can do to support this at the moment.