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:
Or you will see in your logs on Power BI:
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/
Waiting for the next update on a resolution.
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.
Enjoy!
