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.
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?
You can connect trello with PowerBI through their API.
https://developers.trello.com/
Quality over Quantity
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?
Quality over Quantity
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |