Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

project online custom fields

Hi Friends,   I have created many custom fields in Project Online and using those into my enterprise project. I want to use those fields in Power BI but I neither see those fields in Power BI deskt...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi,

I also have created some columns custom fields in Project Online I want to extract those columns in Power BI but I neither see those fields in Power BI desktop (I used Oflux data). 

Also I browsed the content of the forum saying that we need to update the data from the WEB through XML language but how do we get there?

1/ Get data from another source : WEB

     Address: https://xxxxx.sharepoint.com/sites/xxxxxxx/_api/ ?

 

or 2/ Get data from another source: Import XML Code

Source = Xml.Tables(Web.Contents("https://xxxxx.sharepoint.com/sites/xxxxx/_api/ProjectServer/Projects?" &

"$expand=Tasks&$select=Id" &

",Tasks/Id" & ",Tasks/OutlineLevel" &

",Tasks/OutlinePosition" &

",Tasks/Texte1" &

",Tasks/Texte2" &

",Tasks/Text3" &

",Tasks/Nomdelatâche" &

",Tasks/WPLeader" &

",Tasks/SupplierName" &

",Tasks/Fin" &

",Tasks/Finderéférence1" &

",Tasks/category" &

",Tasks/%achevé" &

",Tasks/Variance(calendardays)"))

 

?

 

Thank you for your help

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    No.. I created in microsoft project custom columns and I would like to import these custom columns in power BI except that the O FLUX DATA transaction does not extract them. By browsing the exchanges on this forum I saw that the extraction of these custom columns was possible through the generation of an XML code and I would like to know the step by step of this solution