Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

msbasanth

Access to ADO ODATA Feed from PowerBI is fails from a service account

Submitted by Tuesday

Hi,

 

We have a service account with UPN for tool automation. It is having required permissions ADO and PowerBI Pro license etc. It is failing connecting odata feed, I am trying from PowerBI Desktop to retrieve WorkItems snapshot.

 

msbasanth_0-1734428501524.png

 

msbasanth_1-1734428634494.png

 

I am able to login to ADO using the same service account and I am able to view the queries in the analytics section in UI. So it looks like I am missing very specific permission which does not allow me and gives "Access to the resource is forbidden" when trying to add as data source in PowerBI.

 

msbasanth_2-1734431065513.png

 

This is the odata query I am using (after combining this)

 

 

https://analytics.dev.azure.com/ABCD/ABCD/_odata/v3.0-preview/WorkItems?
        $filter=WorkItemType eq 'Bug'
            and State ne 'Terminated'
            and State ne 'Done'
            and State ne 'Removed'
            and startswith(Area/AreaPath,'ABCD')
        &$select=WorkItemId,Title,State,TagNames,CreatedDate,Custom_CVSSScore
        &$expand=Iteration($select=IterationPath),Area($select=AreaPath)

 

 

 

Status: Investigating

Hi  @msbasanth ,

 

Does this service account has the "View analytics" permission in Azure DevOps?This permission is required to access Analytics views and connect to them in PowerBI.Please also make sure that the service account is a member of the Project Administrators or Project Collection Administrators groups. These groups have the necessary permissions to manage access at the project levels.
 
Best regards.
Community Support Team_Caitlyn
See more ideas labeled with:
1 Comment (1 New)
Comments
v-xiaoyan-msft
Community Support
Community Support
Tuesday
Status changed to: Investigating

Hi  @msbasanth ,

 

Does this service account has the "View analytics" permission in Azure DevOps?This permission is required to access Analytics views and connect to them in PowerBI.Please also make sure that the service account is a member of the Project Administrators or Project Collection Administrators groups. These groups have the necessary permissions to manage access at the project levels.
 
Best regards.
Community Support Team_Caitlyn
Idea Statuses