You are currently browsing the tag archive for the ‘connectivity’ tag.

UPDATE: The issue has been resolved. If you still encounter issues, open a support ticket.  

Message:
OData: The feed’s metadata document appears to be invalid. Table: Subject.

 

If you’ve been working with Power BI and pulling data from Dynamics 365, you might have encountered an issue with the OData connection. This applies when connecting to Dynamics 365 either using Power BI, Excel, or even when using the Power BI content packs for Sales Analytics and Customer Service Analytics. You will either get the following error when using Power BI or Excel:

image

Or you will see in your logs on Power BI:

image

This is a relatively recent occurrence (first I’ve encountered it was on Feb. 07, 2018), and it does not affect all environments. It’s been identified as a known issue and logged on the Power BI support site at

https://powerbi.microsoft.com/en-us/support/

image

Waiting for the next update on a resolution.

Advertisements

One interesting case I had just the other day made me look like a fool. Just like in many cases, when you have issues connecting your Outlook to a CRM instance, there are a few basic steps you follow in trying to debug the issue. There is available a troubleshooting wizard at the following URL:

http://rc.crm.dynamics.com/rc/2011/en-us/online/5.0/outlook-troubleshooting.aspx

While this is helpful, one other place to go look at is the folder holding the logs on the client machine. these logs are located at various locations, depending on the version of Windows you are running and type of log you are searching. These are:

Configuration log files

Windows Path
XP C:\Document and Settings\user\Local Settings\Application Data\Microsoft\MSCRM\Logs
Vista & 7 C:\Users\user\AppData\Local\Microsoft\MSCRM\Logs

Setup log files

Windows Path
XP C:\Document and Settings\user\Application Data\Microsoft\MSCRM\Logs
Vista & 7 C:\Users\user\AppData\Roaming\Microsoft\MSCRM\Logs

 

All fine by me, but the situation I had had to do with the fact that the Outlook client was refusing to connect to my CRM instance while using IE it worked just fine. The Sync to Outlook was enable in the security role, and all looked just fine.

Finally, one of my colleagues stumbled upon an interesting piece of information. In the security role the users that could not connect had assigned, on the Business Management tab, under User Settings, we only had Read across the Organization enabled. Changing the Write setting to User allowed now all Outlook clients for the users of this group to connect.

image

Enjoy!

Microsoft Business Solutions MVP

Check out my course [Video]

Getting Started with Dynamics 365 Customer Engagement

Reviewed Book

Implementing Microsoft Dynamics 365 for Finance and Operations

Implementing Microsoft Dynamics 365 for Finance and Operations

Reviewed Book

Microsoft Dynamics 365 Extensions Cookbook

Microsoft Dynamics 365 Extensions Cookbook

Check out my Book

Microsoft Dynamics CRM 2016 Customization - Second Edition

Microsoft Dynamics CRM 2016 Customization - Second Edition

Check out my Book

Microsoft Dynamics CRM Customization Essentials

Microsoft Dynamics CRM Customization Essentials

Check out my Book

Microsoft Dynamics CRM 2011 Scripting Cookbook

Microsoft Dynamics CRM 2011 Scripting Cookbook

Reviewed Book

Microsoft Dynamics CRM 2011: Dashboards Cookbook

Microsoft Dynamics CRM 2011: Dashboards Cookbook

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 484 other followers

Follow Dynamics 365 Wizardry on WordPress.com