Hah perhaps…
While it’s possible to extract this data into Power BI, taking a bunch of document-oriented data and modeling it in a more “traditional” relational/tabular format takes a lot of work, and there are some Power BI specific workarounds required to make it all work. For example, you cannot make a “join” using more than one join key in Power BI, you must concatenate your two join keys together into their own custom column, and then remember that’s why you did that.
In the future, I’d like to look into ingesting this data into our data warehouse so that the modeling can be done using SQL and then just have Power BI pull directly from views that we model.