How to export Timeline view to Gnatt chart view
Suman Saranu
I'm New Here 
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
1 answer
David Nickell
Rising Star 
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
From within Excel you can execute Power Query Code to extract Work Items and Associated Work logs. Whatever tool you use, it starts with REST API calls (you already have access to)
Assuming you were going to export a list of items anyway, you can make the Worklog endpoint call directly in excel using Power Query
https://YOUR URL.atlassian.net/rest/api/3/issue/issueIdOrKey/worklog
Its the same code wether you run in Excel or Power BI. You will need to do some pagination and some data formatting. For example, durations are in seconds I believe.
In this example, I am using the data in Power BI
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.