trackday using asana

I've asana datasource https://app.asana.com/

I'm able to connect to datasource.

The source is like:

idtask|assigned name|compeletedat|startat|phase

12|test1|02/02/2022|01/02/2022|phase1

I'd like to track velocity and understand how long each phase generally takes.

Actually, Asana doesn't provide such information. We can only track creation, completion and due dates, but not the duration of each phase. There isn't a direct way to calculate the time elapsed between two phases for example.

I have a project in Asana set up as a Kanban board with column denoting different phases from Backlog → Scoping → Dev Ready → In Progress → QA → Released (for example). To track overall progress and performance, I want to measure how long an issue/task is in each column (e.g. how long a new issue goes from the Backlog to being DevReady, etc. 

Is there a way to use powerbi to historize data, track all status?