Forum Discussion
Permissions required for OData access projects
Hi Frede ,
If you are querying multiple projects, you should limit the query to the projects you have access to. Also, specify the project filter in the $expand clause if your expansion could include data in other, potentially inaccessible projects.
OData Analytics query guidelines - Azure DevOps | Microsoft LearnIt’s crucial to ensure that the appropriate permissions are set correctly to maintain the security and integrity of your data. Always follow your organization’s guidelines when requesting additional permissions.
About permissions and security groups - Azure DevOps | Microsoft Learn
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group
Thanks a lot for your reply, I was able to get things working after filtering for project in the expand clauses as well
My OData.Feed query now looks like this.*
= OData.Feed ("https://{organization}/_odata/v3.0-preview/WorkItems?"
&"$filter=(Project/ProjectName eq 'Project1' OR Project/ProjectName eq 'Project2')"
&"&$select=WorkItemId,Title,WorkItemType,State,TagNames "
&"&$expand=Area($select=AreaPath), "
&"Links( "
&"$select=LinkTypeName; "
&"$expand=TargetWorkItem($select=WorkItemType,WorkItemId,Title,State;$filter=Project/ProjectName eq 'Project1' OR Project/ProjectName eq 'Project2') "
&") "
,null, [Implementation="2.0",ODataVersion = 4])
So now I am querying all project, but filtering for specific projects in the 2 expand sections. Ensure that you have permission to the projects that are included in the filter.