Getting the Dependencies from OData

[justin777]

Hi Guys, 

I'm currently creating a report right now and one of the table is that I need to print all the dependencies the project has. 
In Project Online we can see this by connecting a tasks from each other so when the tasks is done we can procceed on the project. 

I have check the fields on OData but did not saw how it was being track.

Thanks

[TonyPMORoadmap]

Hey there Justin, I'm sure you've already solved this by now but hopefully we can help other folks in the future. Great question and it also happens with other fields like Constraints also. The best way to do this is to create an Enterprise Custom Field (ECF) in your environment at the "Task" entity level and then you can add most all of the fields from the schedules. After you add it, refresh your data connection and make sure if you're filtering out fields in your PBIX file that you add your new fields. 

I don't recommend that you do a full 14 pt DCMA this way but dependencies and contraints are good choices.

Hope this will help others in the future.

[v-yuezhe-msft]

@justin777,

Please check if query dependency  in Power BI Desktop meets your requirement.

Regards,
Lydia

[justin777]

Sorry if I was not clear enough, I was talking about inter-project dependencies

https://support.office.com/en-us/article/create-and-manage-inter-project-dependencies-2312f1a0-e7c1-...

[v-yuezhe-msft]

@justin777,

I am afraid that the same thing can't be achieved in Power BI.

Regards,
Lydia