Odata Loading issues

[Anonymous]

Hello eveyone,

I'm using my sitecore xconnect instance's Odata Feed as a source. When my data has multilevels and using @odata attributes I can't access it with Power BI. But when I try to access the feed with postman or browser I can see it without an issue.

This is how my data looks like in postman

    "@odata.context": "https://sc92.xconnect/odata/$metadata#Interactions",
    "@odata.count": 3,
    "value": [
        {
            "EngagementValue": 20,
            "StartDateTime": "2019-10-15T08:47:06.2206816Z",
            "EndDateTime": "2019-10-15T08:47:06.2206816Z",
            "ChannelId": "86761432-fdbb-4c4b-afae-557130ae4d61",
            "Initiator": "Brand",
            "UserAgent": "Sample User Agent",
            "Id": "0942714d-3104-0000-0000-05ade5e1d1aa",
            "ConcurrencyToken": "1216f20b-2c92-4c30-8d04-73882a0dd76c",
            "LastModified": "2019-10-15T08:47:06.2826827Z",
            "Contact": {
                "@odata.id": "/Contacts(0942714d-3104-0000-0000-05ade5e1b51c)"
            },
            "Events": [
                {
                    "@odata.type": "#Sitecore.XConnect.Goal",
                    "CustomValues": [],
                    "DefinitionId": "87431b9b-fa39-4780-beb3-1047b9e61876",
                    "EngagementValue": 20,
                    "Id": "b8dbdc30-34c2-479a-9c24-2a63d2252e13",
                    "Timestamp": "2019-10-15T08:47:06.2206816Z"
                }
            ]
        }
    ]

  I can't access the bold section / Contact info. 

For some properties I get DataFormat.Error: We expected a property 'Id', but the OData service omitted it from the response data. This can occur for a number of reasons and does not necessarily imply that the data does not exist or is of a default value.

Here's another example

When I try to access this DataSourcePath with Postman I have no issues.

Any ideas?

[Icey]

Hi @Anonymous ,

Do you mean that when you connect to OData feed, it is success. But when you expand records, the issue appears? If so, maybe this blog can help you.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @Icey 

Thanks for the reply but unfortunately I can't see the response in Power BI.

This is how data looks

{
            "Name": "Product List Page",
            "DisplayName": "",
            "Path": "/sitecore/content/Core/Home/demo/Product List Page",
            "Language": "de-DE",
            "Version": 1,
            "IsLatestVersion": true,
            "TemplateId": "a8dc74e1-0bbc-4653-b5de-7592b0e6b9d2",
            "TemplateName": "Product List Page",
            "Created": "0001-01-01T00:00:00Z",
            "Updated": "0001-01-01T00:00:00Z",
            "ParentId": "7b79bb4c-e25d-4deb-a994-bdad4bd84d9e",
            "Id": "0085bbee-8062-46d8-9d02-1c8ca0a920af",
            "Url": "http://starter.sc/sitecore/api/ssc/aggregate/content/Items('0085bbee-8062-46d8-9d02-1c8ca0a920af')",
            "StandardFieldValues": {
                "__Workflow": "{A5BC37E7-ED96-4C1E-8590-A26E64DB55EA}"
            }
        }

I want to get the Workflow field value.  This is how it looks on Power BI

 

And I only get a count field when I follow the post you sent. Also all of the values are 0 for some reason.