Have anyone done connection of Workfront to PowerBI for reporting? Did you use fusion for connection? Where did you store the data, in Workfront or Azure or use another data storage solution?
We haven't used PowerBI for any current reporting. I know that with the Dashboard Canvas that some items will be reportable via PowerBI through AEP, so I would recommend starting with AEP.
I'm digging through a PowerBI solution that I have had running for a few years now; looking to change this implementation to eliminate the need for a personal gateway running on my laptop for the refresh to work in the cloud, but this thread shows 'a way' to bring Workfront data into PowerBI. Re: Is it possible to do a bulk insert from the Wo... - Adobe Experience League Community - 493150