Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |