Supporting blog for placing Trello on Power BI. Continue reading Power BI and gaps in the Trello data (how to avoid)
Category Archives: power bi
Power BI and gaps in the Trello data (SQL vs NoSQL)
Sometimes when you model Trello with Power BI there are gaps. Welcome to NoSQL. Continue reading Power BI and gaps in the Trello data (SQL vs NoSQL)
Connecting Private Trello Board to Power BI (without the API)
In theory, any private Trello board will connect with Power BI by using the Trello API. In practice this can get quite technical and, frankly, off-putting. Continue reading Connecting Private Trello Board to Power BI (without the API)
Building a Trello Data Model in Power BI
Once your Trello data is accessible within Power BI it is necessary to make it self-aware. That is, the lists, labels and checklists need to know to which cards they belong; the cards need to know which list they are in. That is, we need to build a data model. Continue reading Building a Trello Data Model in Power BI
Getting Actual Trello Cards into Power BI
Now that Trello and Power BI are talking to each other, we need to give them something to talk about. To do this follow these instructions. Continue reading Getting Actual Trello Cards into Power BI
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.) Continue reading Connecting Trello to Power BI for the first time
Linking Trello to Power BI – Overview
A big help when measuring Trello is that Power BI knows something about Trello that you may not: Behind every board on Trello is a JSON file. Don’t worry if that makes no sense, let Power BI do that for you. Continue reading Linking Trello to Power BI – Overview
