Datasource.Error:Odata: unsupported query option:$expand

[Anonymous]

Hello,

My requirement as to merge couple of tables and exapand the result. Earlier it was working fine but suddenly it's stopped working and getting :$expand error. Can anyone help 

 

[v-jingzhang · Accepted solution]

Hi @Anonymous 

The following links should be helpful. 

Project Server, Power BI & ODATA (microsoft.com)

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

According to this document: 

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

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[amitchandak]

@Anonymous ,Please check, seem like some column has been renamed or removed at source used in merge