Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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 relationships between these tables.
However, when I go to link to the Deliverables Table during setup, I need to expand the Project section in the Deliverables Table to be able to see important parameters such as the source/destination file names of the deliverable, Task Related information such as Task UniqueIDs, etc.
Unfortunately, when I expand the column(s) for Dependent Projects, Dependent Tasks, Partent Projects/Tasks, etc. and select the desired fields, it produces an error: Unsupported query option encountered $expand. Data Source kind: oData.
Any idea how to access these fields?
Hi All,
Trying to revive this thread 🙂 I am also getting the same error for a OData Feed source.
DataSource.Error: OData: Unsupported query option encountered: $expand
Details:
DataSourceKind=OData
DataSourcePath=<#Removed the URL for my data source that was present here#>
Any help will be much appreciated! Thanks!
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.
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.
Currently I am having a problem that looks like your.
I am conecting my data sources with the Enterprise's Project Server. Those projects have some customized Columns, as "% Buffer Consumed", "% Critical Chain Consumed", and others.
What I want is to expand my tables, to see these columns (e.g. Tasks Table), but when I do this, i get the same error:
If anyone knows how to solve this, i'd really be Thankful!
So this is pretty old, but did anyone ever figure out how to do this? Or a workaround to bring in the deliverables + parenttasks details?
Trying to connect deliverables to related tasks, unfortunately no link except in the tables would like to expand but can't.
Currently I am having a problem that looks like your.
I am conecting my data sources with the Enterprise's Project Server. Those projects have some customized Columns, as "% Buffer Consumed", "% Critical Chain Consumed", and others.
What I want is to expand my tables, to see these columns (e.g. Tasks Table), but when I do this, i get the same error:
If anyone knows how to solve this, i'd really be Thankful!
It seems the OData endpoint did not implement the $expand operator, maybe the join is too expensive for the service? The only way you can get these data is by also importing the FK tables, and then do a local join via Merge.
hi, you mention FK tables ... where/how does one access these please?
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
93 | |
89 | |
83 | |
75 | |
49 |
User | Count |
---|---|
142 | |
140 | |
110 | |
69 | |
55 |