Jira PowerBI: Automatic renaming of Columns to real field names

I share here how I have improved my Jira PowerBI Template to automatically rename the field columns by the real field names instead of their Ids.

Handling Web.Request Errors in PowerBI M language

I share here how I have improved my PowerBI Jira Template in respect of field selection flexibility.

PowerBI Formula.Firewall Error: how to handle

I share here how I have solved this PowerBI error.

PowerBI: How to import an Excel file located in a SharePoint

I share here a recent learning about how to load data from an Excel file located in a SharePoint into PowerBI.

PowerBI: How to reorder a Legend

I share here a learning about how to reorder a Legend in a PowerBI Chart.

PowerBI and Charticulator

I have come to learn recently about Charticulator, looking for the possibility to draw Scatters plots with categorical data. It seems to be a Microsoft opensource extension for more powerful charting and can be easily added to PowerBI Desktop.

PowerBI/ PowerQuery: How to get Jira Issue Field Value by Name

I share in this post my learnings and code regarding how to get a field value of a Jira issue in PowerBI/ PowerQuery.

Jira to Power BI

I have worked on an improved version for importing a Jira filter into Microsoft Power BI.
The main advantage of the new approach is that it will import only the fields as defined in your filter columns and also the expanding and renaming from field Ids to real field names is done automatically. (WYSIWYG)

Jira to PowerBI (List based version)

This post is a bit obsolete and was superseded by this version. I prefer a recursive approach to this List / Loop based one. The recursive approach doesn't require to check before for the total number of issues and is more generic for any Rest Api Pagination handling (e.g. HCL Connections export)

I keep this post here for reference.

I have worked on an improved version for importing a Jira filter into Microsoft PowerBI. (My previous solution with a recursive approach wasn't working anymore.)

Main advantage of the new approach is that it will import only the fields as defined in your filter columns and also the expanding and renaming from internal field names to display names is done automatically. (WYSIWYG)

Connections Excel Tool Presentation

This post is a placeholder for a potential presentation. 

It was submitted to DNUG Connections German User Group https://dnug.de/call-for-abstracts/

Jira to Power BI (Recursive approach)

It is not so obvious to get data from Atlassian Jira into Microsoft Power BI. I share here my learnings and solution about it.

Update: see improved version