I work with data but I look for truth. Let me explain: Below is an example of a datum: 42
Category Archives: business analysis
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