Forum Discussion
Project for the Web - Project Tasks Custom Fields - Power BI Reporting
Hello, We're able to add custom fields to Project Tasks table in the Project for the Web, which is a great feature. However, according to this documentation (https://support.microsoft.com/en-...
Hi
Whilst you can't use the custom fields, Microsoft have recently added Label's and To-do lists (and are soon to add Priority) as supported custom fields (ie they are avaialable for Reporting in Power BI)). So against each task you can use, Buckets, Labels, To-Do lists and shortly Priority in Project for the web and use in Power BI.
If you need to add signifantly more data against the tasks and are using Project for the web Power Platform model driven app you can add whatever custom fields, you want to the Project Tasks table (which is where all the tasks from Project for the web are sync'd to). You can use the app or Power Automate to maintain this data and all these modifications are available in Power BI.
Duncan
Whilst you can't use the custom fields, Microsoft have recently added Label's and To-do lists (and are soon to add Priority) as supported custom fields (ie they are avaialable for Reporting in Power BI)). So against each task you can use, Buckets, Labels, To-Do lists and shortly Priority in Project for the web and use in Power BI.
If you need to add signifantly more data against the tasks and are using Project for the web Power Platform model driven app you can add whatever custom fields, you want to the Project Tasks table (which is where all the tasks from Project for the web are sync'd to). You can use the app or Power Automate to maintain this data and all these modifications are available in Power BI.
Duncan
Duncan_Griffin are labels available to be seein in power bi reporting? How do I add these into my power bi models. I’m using project accelerator as a starting point for my project power bi reports.
Yes ndrogo- they can be added to Power BI, you will need to update your Power BI Report to include those tables in the data model. At the end of this blog post I detail the tables you will need to include:
Paul
Paul_Mather Thank you this is perfect.
Thanks for this Could you offer any help on what the relationships should be for the Project Labels and Project Task To Label with the other tables and Task. I'm having trouble with the joins
