Forum Discussion

JimAksel's avatar
JimAksel
New Member
10 years ago

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...
jvaught's avatar
jvaught
Advocate II
8 years ago

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.

ccharker's avatar
ccharker
Frequent Visitor
8 years ago

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.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I am also having the same issue with the Deliverables. Connecting Power BI Desktop to Project online. 

    I do believe the issue is when I look at the Deliverables table in the Query it is blank. I do not know why this table has no data as it seems there should be plenty looking at the titles of the columns. 

     

    I am trying to have a report which lists all the projects then tasks with actual work hours. with no ParentIdName field this is very hard.