Forum Discussion

Jimpie's avatar
Jimpie
New Member
3 years ago

PowerBI automation question

Hey Power BI community,


I am currently working on my graduation research and I got a question. I am working with an research framework (Intel Owl). This framework provides me with a large an complicated json file. This file has multiple lists in it.

I am currently working with python to get the json results from the framework. Is it possible to get this results in Power BI?


The most essential part is getting the data from inside the json and visulise this within the power BI. Do you guys have any suggestions that I can try?


Thanks in advance   

Need Help

1 Reply

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    3 years ago

    Hi Jimpie 

     

    You should be able to import the JSON file and then traverse the different elements. You might have to create a table per element?