How do I export JIRA data to Excel Power Query?

[Hillol Das]

I am currently using Get JIRA Data in Excel to get data from JIRA.
However, I am currently using Macros after exporting the data from JIRA.

I want to do the steps in Power Query without having to run the macros.
I am using Get Data and then pasting the URL of the filtered segment I created in JIRA.
But I am not getting any data in tables and only an HTML document.
How can I solve this issue?

[Aron Gombas _Midori_]

One route you could take is developing a custom Excel export template which includes the VBA macro! If you export with that template, the macro will be automatically executed for you.

Our Better Excel Exporter app supports this flow! Here is a sample macro that does a little processing on "Due Date" and displays a message dialog with the results:

(Discl. it is a paid and supported app developed by our team. Free for 10 users!)