Aug 31 2018 08:50 AM
Hey,
I have a query like this
WITH flat AS (
SELECT
Newsreporting.context.device.osVersion as osVersion,
Newsreporting.context.device.browser as browser,
newsreporting.context.custom.dimensions.News as News,
OM newsreporting
OUTER APPLY GetArrayElements(newsreporting.context.custom.dimensions) MyDimension
)
SELECT
osVersion,
browser,
News
INTO OutputPowerBI
FROM flat
The input for this query is a json file.
Formatted JSON Data
{
"context":{
device":{
"osVersion":"Windows 10",
"browser":"Internet Explorer",
},
"custom":{
"dimensions":[
{
"News":"Portal"
},
]
}
}
The News returns all time null. How can I fix it?
But how can I flat the custom.dimensions section?
Thanks for your help
Stefan
Sep 08 2018 03:25 AM