Mongodb Error

[Jyo27]

Hi everyone,

I'm fetching data from mongodb to Power bi desktop and I was unable to load all the columns from mongodb . How can i fetch arrays from mongodb to power bi ?

Example :

{
"_id" : "ABC",
"name" : " CDE",
"Data" : [
{
"A" : "XXXX",
"B" : "YYY",
"C" : "ZZZ"
}
]
"date" : 1568836186371.0,

}

[Jyo27]

If I export mongo data to JSON file and upload this file in Power BI ,Will the report be dynamic ?

Whenever new data is added in mongo ,will it show new data in power bi with this JSON file ?

[amitchandak]

@Jyo27 , The data should be in json format and in power query you should be able to expand the json file

example

How to import JSON Data: https://youtu.be/MPYfEetvFH4