Forum Discussion
Project Online Data Error: DataSource.Error: OData: Unsupported query option encountered: $expand
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
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/project-server-power-bi-odata?forum=projectserver2010general
Best Regards,
Qiuyun YuHi KCinMelbourne,
You can vote this same idea: https://microsoftproject.uservoice.com/forums/218133-microsoft-project/suggestions/32457356-implement-navigation-properties-in-project-onlin
Best Regards,
Qiuyun Yu
6 Replies
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/project-server-power-bi-odata?forum=projectserver2010general
Best Regards,
Qiuyun YuHi 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- 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
Hi KCinMelbourne,
You can vote this same idea: https://microsoftproject.uservoice.com/forums/218133-microsoft-project/suggestions/32457356-implement-navigation-properties-in-project-onlin
Best Regards,
Qiuyun Yu- Thanks, that's perfect! Please feel free to mark this as solved/complete.
