Project Online - Assignments ODATA Feed

[AndyTrezise]

Hi All

I'm using ODATA connector to take data out of out Projects Online system.

Most of the tables are associated - Projects -> Tasks -> Assignments -> Resources

I can model the data quite easily and link the tables on their associated columns however I get the opportunity using Query Editor to choose columns from other tables however if I try this I get an error.

I tried to merge two queries and do the same bt I got the same error.

It doen't appear to matter which tables I merge I always get a similar error that suggests ODATA $expand is uable to join the tables?

Any help much appreciated.

[v-yuezhe-msft · Accepted solution]

@AndyTrezise,

The above error could be due to that the ProjectData service does not implement the $links query option or the $expand query option, for more details, please review this similar blog.

In your scenario, I would recommend you connect to .PBIT file of Project Online.

https://github.com/OfficeDev/Project-Power-BI-Content-Packs
https://gallery.technet.microsoft.com/office/Microsofts-Online-Power-BI-0260454a

Regards,
Lydia