Forum Discussion
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...
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.