Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Power Query - Filter on multiple conditions

i am trying to limit the amount of data in Powerbi when i connect to my work's VSTS/AzureDevOps instance   if i connect all work item types i am hitting a timeout problem. lots of data. approx 2mil...
Need Help
arsaveli's avatar
arsaveli
Helper I
6 years ago

Which entity are you querying in DevOps? Do you actually have 2 million work items, or are you querying WorkItemSnapshot?

FYI WorkItemSnapshot is not designed to be exported like this - you have to aggregate your data for consumption.

 

You can create the filter you are talking about in the odata query you are running - if you are using analytics views, you can create two views and do a UNION on them in PowerBI.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    arsaveli 

     

    thanks for the reply

    im taking in the Workitems - history by month data

     

    long story short, ive spoken to PowerBi team in MS and odata will not suit my needs.

    been informed that ill need to use the "Azure DevOps (beta)" connector

     

    im happy to be told otherwise, its what ive been discussing with MS. ive been through beta and preview testing

     

    anyhow. possibly ill create different connections to the data. and filter out rule as needed

    any other thoughts?