Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
In Power BI, click:
The next three steps are the most important we shall cover:
NB all of your changes from this point on will be on the new query. 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.
Fortunately, Power BI does this for us:
At this point take a moment to look at the right hand side of the screen and notice that Power BI has completed a list of the steps taken so far. Great news, it will perform them every time you refresh the report – you don’t have to do anything – and hence all of your Trello data is there (and brilliantly Trello remains the single version of the truth).
At this point the key elements of Trello data are available to us in tables. However the tables are at this juncture unaware of each other. We will address this in the next section when we will be Building a Trello Data Model in Power BI
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.