Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Jimpie
New Member

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   

1 REPLY 1
GilbertQ
Super User
Super User

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?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

Top Solution Authors
Top Kudoed Authors