The way that Particle publishes the data in one array doesn’t work for my application in Power Bi. When my data pushes out to my Azure integration I need it separated so that when I pull it into Power bi it will be separated into it’s own columns. Is there a way to change the custom JSON so that it will do this?
My JSON now:
{
“event”: “{{{PARTICLE_EVENT_NAME}}}”,
“data”: “{{{PARTICLE_EVENT_VALUE}}}”,
“device_id”: “{{{PARTICLE_DEVICE_ID}}}”,
“published_at”: “{{{PARTICLE_PUBLISHED_AT}}}”
}
How the data comes into Power Bi:
