Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Pulling data from JSON in Power BI

Hi Team,   I am pulling data from MongoDB in Power BI and data is in document format.   ( id:- 1 name :- Shubham Position :- Developer } ( id:- 2 name :- Swapnil Position :- Senior Develo...
Need Help
Show and Tell
v-lili6-msft's avatar
v-lili6-msft
Community Support
6 years ago

hi  Anonymous 

I have test on my side, it works well.

 

and here is power query code:

 

 

let
    Source = Json.Document(File.Contents("C:\Users\linli\Desktop\test.json")),
    #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"id", "name", "Position"}, {"id", "name", "Position"})
in
    #"Expanded Column1"

 

 

 

 

Regards,

Lin