topic Re: Azure Devops Server connector issue in Developer

Azure Devops Server connector issue

Anonymous — Wed, 25 Dec 2019 14:57:36 GMT

We tried to use Azure Devops Server (Beta) connector and it takes very long time to load data from model (couple of hours).

After we publish the report to the server the data not shown at all.

Any suggestions?

Re: Azure Devops Server connector issue

v-chuncz-msft — Thu, 26 Dec 2019 10:06:15 GMT

@Anonymous

Views that pull a large amount of data, might take a long time to refresh and load in Power BI. For organizations with a large amount of data, it might even fail to load. To make sure your view will successfully load in Power BI, Verify your view before saving it.

Note that Analytics Views do not apply filters that have defined using Power BI on the server. Any filters applied in Power BI will limit the data shown to end users but will not reduce the amount of data retrieved from Analytics. If the filter is intended to reduce the size of the dataset, it should be applied by customizing the view.

Alternatively, you may try Connect using OData queries and Connect using Advanced Functions.

Re: Azure Devops Server connector issue

Anonymous — Sat, 28 Dec 2019 20:29:29 GMT

Hi!

@v-chuncz-msft Thank you for the response.

We verified the data as you suggested and it works just fine (about 7000 recoreds).

It looks like the POWER BI trying to get the full data from data base with out any filters.

Michal