Forum Discussion
CRM and missing fields
Unfortunately I've been using the Desktop client and I still have missing fields.
The Desktop client will have access to the full CRM Online OData feed so if the fields are available you should be able to access them. The feed will also expose all the data you have access to in CRM so it's suggested that you apply filters (such as created in the last year) to ensure you're dealing with a managable set for your reporting.
While the content pack also uses the CRM Online OData feed, it has customized queries that may join values from multiple tables. As another user said, it's possible you need to do a transformation such as expand, in order to expose those fields as you're seeing them in the content pack. The documenation on the CRM Online OData feed should provide more guidance on where to find each field.
I'm still having this problem,
Was a cause / solution found to fix it?
I need to create a report for my organization that shows leads by their status and status reasons but these aren't showing in my data feed on Power BI.
I've also seen videos online where people get data from their CRM instances and it comes down with just the entity names such as 'Lead', 'Account', 'Contact', but for me I see various options for data'sets', such as 'AccountLeadsSet', 'AccountSet'... or 'ContactLeadsSet', 'ContactOrdersSet', 'ContactQuotesSet', 'ContactSet'.... I don't know if this is related and perhaps i'm not connecting to my CRM instance in the right way - happy to create a seperate thread about this if it's not related.
I'm connecting through https://myorganization.crmXX.dynamics.com/xrmservices/2011/organizationdata.svc
Trying to search online for answers around this isn't bringing back much - hoping someone on here can help.
Thanks
