cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
EldadCohen
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
v-lid-msft
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
v-lid-msft
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
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

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.