flat a json file

Question

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

jcgonzalezmartin · Answer

This forum is devoted to Microsoft Stream and not to JSON matters so I think you are going to help more support if you post it in the right forum

Forum Discussion

flat a json file

1 Reply

Resources