Getting duplicate records when displaying reports in PowerBi that read from Visual Studio Online RRS feed

  • General discussion

  • Hello,

    I'm connecting to VSO from PowerBi and trying to display basic reports. 

    I'm selecting the fields from the Work Items section like "Title", "Assigned to name" and "workitemtype". I have a total of 4 tasks only in VSO, whenever i add the field Title, i get in the reports duplicate rows for some of the tasks. You can see in the attached screen shot how "design document" for ex. appears 3 times, whereas another task appears only once normally. 

    Can you please help. 



    Sunday, January 17, 2016 6:59 PM

All replies

  • Hi Elsa,

    I have a similar problem. Did you find workaround on this?

    Monday, November 7, 2016 2:16 PM
  • Did you find a solution to supress the repeating values? I found a "Rev" field under the Work Items table that appears to be a revision number (I think) but I can't figure out how to filter my list of tasks using the max rev value. 
    Thursday, March 23, 2017 8:09 PM