Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Data source question: Trello or PowerApps (SharePoint/Excel) pros and cons

Hi all,

 

Our company is in the follow situation:

 

We have a weekly Friday meeting, in which we all get up to date on current and future projects. Each project has a variety of data stored such as "Client Budget", "Start Date", etc. etc. We want to use Power BI to make financial forecasting on a short- and medium-term basis.

 

Currently we are deciding between two approaches:

 

1. We either want to go with "Trello" which is very good in terms of user experience, but it is not a data source, which is supported by Power BI currently. Hence we will need to manually extract the data into Excel on a weekly basis, change the table and then add it to Power BI.

 

2. We have a ready PowerApp, which has been created to serve the same purpose. The application does 90% of what the Trello does, but currently does not have commenting as well as assigning people to different projects. It lacks in user experience (slow at times and as mentioned some missing features). However, as the data source we use gets updated automatically through the application and that data source is connected to Power BI it saves us time and removes possible errors that might occur with extracting the data etc.

 

My question is therefore: What is your opinion? Which approach would you suggest?

Need Help
Tips and Tricks

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Anonymous 

       

      Interesting. I have been trying to look into this, it seems a bit tricky and the data is not very clean when importing it. As our board is private I need to extract the JSON file. Is this the approach you mean?

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago
        To be honest i have never used the API. I know you can use the Web connector in PBI to connect to the API. I wouldn't know how the data will look like or how to influence this. I just know you can connect trello with PowerBI 🙂 Goodluck!
  • DataChant's avatar
    DataChant
    Most Valuable Professional
    10 months ago

    For anyone who wants to analyze Trello data in Power BI (without manual export of data from Trello), I have released a comprehensive open-source project on GitHub with the Power BI project files that include robust Power Query logic (including the API implementation). The queries handle many of the Trello objects using the Web Connector. The report includes the relationship, DAX measures and some basic visualization that analyzes completion rates, inactive members and card returns.

     

    Learn more: here

    GitHub repo: here