cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

Azure TFS Server - Collection

Hi,

 

Is it possible to analyitc in Collection level ? I do nto want join each project in my collections.

Note I also have few collections.

 

Thanks

 

 

3 ACCEPTED SOLUTIONS
Community Support
Community Support

Hi @EldadCohen ,

 

If you are using Azure DevOps Server Connector, based on this document: https://docs.microsoft.com/en-us/azure/devops/report/powerbi/data-connector-connect?view=azure-devop...

 

For Organization, enter the organization name in Azure DevOps (not the full URL). For example, use fabrikam-fiber-inc if the URL of your organization is "https://dev.azure.com/fabrikam-fiber-inc./".

 

For Team project, enter just the project name (e.g. use Fabrikam-Fiber if the URL of your project is "https://dev.azure.com/fabrikam-fiber-inc./Fabrikam-Fiber“).


If it doesn't meet your requirement, Could you please provide more details about your requirement?

 

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Hi @EldadCohen ,

 

Based on this document, you can omit "/{project}" entirely for a cross-project query.

 

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Hi @EldadCohen ,

 

Sorry for that, we did not found any official wizared tools to simplify creation of OData queries. Here is a quick start about how to connect oData queries: https://docs.microsoft.com/en-us/azure/devops/report/powerbi/odataquery-connect?view=azure-devops

 

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
Community Support
Community Support

Hi @EldadCohen ,

 

If you are using Azure DevOps Server Connector, based on this document: https://docs.microsoft.com/en-us/azure/devops/report/powerbi/data-connector-connect?view=azure-devop...

 

For Organization, enter the organization name in Azure DevOps (not the full URL). For example, use fabrikam-fiber-inc if the URL of your organization is "https://dev.azure.com/fabrikam-fiber-inc./".

 

For Team project, enter just the project name (e.g. use Fabrikam-Fiber if the URL of your project is "https://dev.azure.com/fabrikam-fiber-inc./Fabrikam-Fiber“).


If it doesn't meet your requirement, Could you please provide more details about your requirement?

 

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Thanks on the quick response.

I was referring to Azure DevOps 2019 Server On Premise .

My original requirement was to connect to Collection and to start working on information from the whole collection , I.e. all project under a Collection.

My motivation is to create BI report on all projects under my Collection.

 

Thanks

 

Hi @EldadCohen ,

 

Based on this document, you can omit "/{project}" entirely for a cross-project query.

 

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Hi,

 

Thanks for the info, Yes It seems the correct solution.

1. Is there any OData queries wizared to simplify creation of OData queries ?

2. I also noticed that I can add project in my View on Azure DevOps.

 

Thanks

Hi @EldadCohen ,

 

Sorry for that, we did not found any official wizared tools to simplify creation of OData queries. Here is a quick start about how to connect oData queries: https://docs.microsoft.com/en-us/azure/devops/report/powerbi/odataquery-connect?view=azure-devops

 

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors