Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
Anonymous
Not applicable

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?

3 REPLIES 3
EricHulshof
Solution Sage
Solution Sage

You can connect trello with PowerBI through their API.

 

https://developers.trello.com/


Quality over Quantity


Did I answer your question? Mark my post as a solution!


Anonymous
Not applicable

@EricHulshof 

 

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?

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!

Quality over Quantity


Did I answer your question? Mark my post as a solution!


Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.