We are using PowerBI as a reporting/display layer over our Workfront
data. Using the WF API key, we make calls to Workfront every 30-minutes
to pull data in a large JSON file and then transform that data in
PowerBI to slice, filter, and visualize that data to suit our business
needs. We heavily utilize the milestone pathway to standardize our
projects so that we can compare their timelines side by side even with
differing task names (think Gantt charts, etc.).