Could it, probably. I've used fusion for a few bulk export/import
things. That said, you don't have to put Fusion or SQL in the middle. I
have a Power BI model that pulls in 5 years worth of projects, tasks,
issues, etc direct from Workfront's API using incremental refresh. Took
a little fiddling, but if your comfortable in Power Query you can
traverse all the rows of tasks you have in a single query, and build
visuals against that.. All it takes is a Web connector in Power BI and
some clever M ...