Forum Discussion

SaryT's avatar
SaryT
Frequent Visitor
3 years ago
Solved

Custom Column from MS Project in Power BI Desktop

Hello all,    I know that this issue was already mentioned there, but I am still looking for a solution. I´m creating a dashboard in Power BI Desktop. It´s going to be a Project Portfolio. I receiv...
Need Help
  • SaryT's avatar
    SaryT
    2 years ago

    There is no other solution for that than use the default columns from Project. 

    Microsoft approved that it is not possible to get the custom fields from Project to Power BI. 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi SaryT ,

 

You can use Power Query Editor to add custom columns to your data. In Power BI Desktop, select the "Transform Data" button to open Power Query Editor. From there, you can add custom columns using the "Add Column" tab.

 

                                                                                                                                                         

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi SaryT  Did you find a solution?

    • SaryT's avatar
      SaryT
      Frequent Visitor
      2 years ago

      Yes, we created column in Project Task table in Power Apps which is then visible in Power BI. Now we also need to see this column in Project for the Web, but we can't. 

    • SaryT's avatar
      SaryT
      Frequent Visitor
      2 years ago

      There is no other solution for that than use the default columns from Project. 

      Microsoft approved that it is not possible to get the custom fields from Project to Power BI. 

      • N_Veera_Satish's avatar
        N_Veera_Satish
        Regular Visitor
        2 years ago

        Hi SaryT  Could you please share the Microsoft approved related URL