Project Online Data Error: DataSource.Error: OData: Unsupported query option encountered: $expand

[KCinMelbourne]

Hi guys, 

I'm pulling tables in from Project Online using an OData retrieve. It recognises tables with a relationship and offers the option to expand the related records.  But when you do this, it provides the error: "DataSource.Error: OData: Unsupported query option encountered: $expand".

The result is that we have to pull multiple tables and merge them which is far less efficient.  Would be great to get a fix for this.

Note that I don't think creating a content pack is a solution (as has been suggested in the forums), that's just a work around as is the merge I mentioned above.  As you can see in the following link, there are numerous people facing this issue and I'm sure many more who don't post but just use a work around:

https://community.powerbi.com/t5/Desktop/PWA-Deliverables/td-p/17627

Cheers

KC

[v-qiuyu-msft · Accepted solution]

Hi @KCinMelbourne,

According to this document: 

The ProjectData service does not implement the $links query option or the $expand query option. 

The issue is related to Project online endpoint. You can see: https://social.technet.microsoft.com/Forums/windowsserver/en-US/1b629bd4-08ca-4df8-b755-55d497fbf864...

Best Regards,
Qiuyun Yu 

[v-qiuyu-msft]

Hi @KCinMelbourne,

I will move it to Desktop forum then close this thread. 

Best Regards,
Qiuyun Yu 

[KCinMelbourne]

Thanks, that's perfect! Please feel free to mark this as solved/complete.

[v-qiuyu-msft · Accepted solution]

Hi @KCinMelbourne,

You can vote this same idea: https://microsoftproject.uservoice.com/forums/218133-microsoft-project/suggestions/32457356-implemen...

Best Regards,
Qiuyun Yu

[KCinMelbourne]

Thanks Qiuyun, I did what that blog suggested and brought them in separately and manually merged the datasets together. It certainly would have been substantially easier if the 'expand' option worked though. It would be great if MS could consider this on their backlog. Given the number of queries on it, it is obviously impacting people. I assume it just isn't getting much air in this forum because there is a workaround. Cheers Kirsty

[v-qiuyu-msft · Accepted solution]

Hi @KCinMelbourne,

According to this document: 

The ProjectData service does not implement the $links query option or the $expand query option. 

The issue is related to Project online endpoint. You can see: https://social.technet.microsoft.com/Forums/windowsserver/en-US/1b629bd4-08ca-4df8-b755-55d497fbf864...

Best Regards,
Qiuyun Yu 

[v-qiuyu-msft]

Hi @KCinMelbourne,

Please enable Power BI desktop trace, repeat steps to reproduce the issue. Upload these trace logs to your Onedirve and send the share link to me via private message. 

Best Regards,
Qiuyun Yu