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

Supporting blog for placing Trello on Power BI.

The data behind the Trello board is schemaless and this gives Power BI a problem when writing data models for production. The last thing you or your clients need is to, say, add some labels and not be able to ask questions of it.

Fortunately, there is a really simple way of avoiding this:

  1. Have an extremely “busy” card on the board.
  2. Here is an example of a “busy” card: https://trello.com/c/RQQQilh1
  3. This card has lots of everything and, once that happens, your Power BI board has all of the fields it needs.

 

 

 

(original image: https://d2k1ftgv7pobq7.cloudfront.net/meta/u/res/images/d6f720d361e2251df03f42b5c194e08d/boardbasics-restaurantboard.jpg)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s