CRM and 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 in the midist of initial tests and I had a similar issue with missing fields. In the past when I've selected multiple (2-3) entities to include in a dataset, it's taken 5+ hours of downloading before some issue or another comes up and I have to cancel or it's stopped. Today I selected 9 entities as a test and it finished within an hour. However those entities were missing fields.

it seems to me that some issue occured while it was downloading data and it falsely reported completion. I ran another test, removing my multple entity selection and only chose one entity, and after an hour it finished and had all fields.

Yes you can use this code to get these

let

DataList = List.Generate(
() => [
SourceURI="https:// "URL" /api/data/v9.1/stringmaps"
,Pagecount=0
,Stringmaps = {}
,Source = []
,ErrorTest = try Source = []
]
,each if [ErrorTest][HasError] then false else true

,each [
ErrorTest = try Source = Json.Document(Web.Contents([SourceURI]))
,Source = Json.Document(Web.Contents([SourceURI]))
,SourceURI = Record.Field(Source,"@odata.nextLink")
,Stringmaps = Source[value]
,Pagecount = [Pagecount] + 1
]
),
#"Converted to Table" = Table.FromList(DataList, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"Stringmaps"}, {"Column1.Stringmaps"}),
#"Removed Errors" = Table.RemoveRowsWithErrors(#"Expanded Column1", {"Column1.Stringmaps"}),
#"Expanded Column1.Stringmaps" = Table.ExpandListColumn(#"Removed Errors", "Column1.Stringmaps"),
#"Removed Blank Rows" = Table.SelectRows(#"Expanded Column1.Stringmaps", each not List.IsEmpty(List.RemoveMatchingItems(Record.FieldValues(_), {"", null}))),
#"Expanded Column1.Stringmaps1" = Table.ExpandRecordColumn(#"Removed Blank Rows", "Column1.Stringmaps", {"value", "attributename", "objecttypecode", "attributevalue"}, {"value", "attributename", "objecttypecode", "attributevalue"}),
#"Sorted Rows" = Table.Sort(#"Expanded Column1.Stringmaps1",{{"objecttypecode", Order.Ascending},{"attributename", Order.Ascending}}),
#"Grouped Rows" = Table.Group(#"Sorted Rows", {"attributename", "objecttypecode"}, {{"Count", each _, type table [value=text, attributename=text, objecttypecode=text, attributevalue=number]}}),
#"Grouped Rows1" = Table.Group(#"Grouped Rows", {"objecttypecode"}, {{"Count", each _, type table [attributename=text, objecttypecode=text, Count=table]}}),
account = #"Grouped Rows1"{[objecttypecode="account"]}[Count],
accountcategorycode_account = account{[attributename="businesstypecode",objecttypecode="account"]}[Count],
#"Dubbele waarden verwijderd" = Table.Distinct(accountcategorycode_account, {"attributevalue"}),
#"Namen van kolommen gewijzigd" = Table.RenameColumns(#"Dubbele waarden verwijderd",{{"value", "Option"}, {"attributevalue", "Value"}}),
#"Andere kolommen verwijderd" = Table.SelectColumns(#"Namen van kolommen gewijzigd",{"Option", "Value"})
in
#"Andere kolommen verwijderd"