Forum Discussion
PWA Deliverables
Using Power BI Desktop and have oData Connections to a Project Server 2013 PWA tenant. One such table is the "Deliverables" table. Also of interest is the Projects table and Tasks Table. There are...
I was just told by Power BI tech support to expand that Projects section instead of using a merge. I get the same error though: "DataSource.Error: OData: Unsupported query option encountered: $expand" and have reported this back to them. We'll see what they say since they suggested I do it in the first place.
In the meantime, I'll stick with what I've been doing, which is to add a merge step to the query, then expand the columns as needed.
Hi,
I am struggling with the same issue. Did anyone work out a resolution on how to get access to the required information. I am not experienced in how to use the merge feature to append the required data to the table so I can add it into my Visuals.
Any information would be appreciated.