power bi – Databackwriter Blog

Power BI and gaps in the Trello data (how to avoid)

Dealing with gaps in the Trello data (SQL vs NoSQL)

Power BI and gaps in the Trello data (SQL vs NoSQL)

Dealing with gaps in the Trello data (SQL vs NoSQL)

Connecting Private Trello Board to Power BI (without the API)

Within Power BI press Get Data but instead of choosing Web, choose JSON. Upload the file you just exported.

From this point on the file will behave exactly as the web connected version with the downside that it is not 100% live. To refresh the data, you would need to export back over the top of the original file.

Building a Trello Data Model in Power BI

Lists and labels and cards and checklists need to know about what cards they belong to, the labels need to know to which cards they relate.

Getting Actual Trello Cards into Power BI

This is cool because it means that we have drilled into the data. Next we need to turn this into a table that we can work with.

Connecting Trello to Power BI for the first time

You have your Trello board. You have access to Power BI. You want to make the two of them talk. Here we show how to do this utilising the Trello board as a JSON file. (Do not worry if you don’t know what a JSON file is.)

Linking Trello to Power BI – Overview

This is what a Trello board looks like as JSON

How to: Measure Trello with Power BI

A fundamental tenet of the lean methodology is that you measure. As enterprises large and small move to a lean start-up principles they are using Trello to facilitate this. Here we use Power BI to measure Trello.

Power BI – You don’t have access to this dashboard

You don’t have access to this dashboard

This invitation contains dashboards, reports or data outside of your organisation that cannot be viewed