Forum Discussion
Mongodb Error
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,
}
2 Replies
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
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 ?
