Connecting to multiple projects in VSTS account?

[VSTSadmin]

I am in the process of building some reports based on VSTS  work item data. Choosing to get data and selecting the online service "Visual Studio Team Services Beta" requires me to enter the VSTS account and a single project to connect to. I would the report to pull data from all projects in a VSTS account and not a single project.

Is there any way of connecting to all projects using this online service?

Thanks in advance for any help!

[v-piga-msft · Accepted solution]

Hi VSTSadmin,

From your description, I understand that you want to connect all projects in a VSTS account in Power BI Desktop.

I have tested for many ways but failed. By confirmed by PG, currently the VSTS data connector for Power BI is limited to a set of pre-defined views. We have the plan to provide the ability to create custom views .Custom views can be configured to pull in data from multiple team projects, eliminating the need to perform "Get Data" multiple times.

For more details about Connect to VSTS with Power BI Data Connector, you could refer to the article below:

https://docs.microsoft.com/en-us/vsts/report/powerbi/data-connector-connect

Best Regards,

Cherry  

[VSTSadmin]

Thanks!