Forum Discussion

elsa's avatar
elsa
New Member
10 years ago

Problems with dataset retrieved from VSO

I'm connecting to VSO from PowerBi and trying to display basic reports.   When preparing the dataset, I'm selecting the fields from the Work Items section like "Title", "Assigned to name" and "Work...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

Hmm, I connected to my VSO account and took a look. I am definitely seeing what you are seeing. I note that Title is the only item in Work Items that has that particular little icon next to it. Not entirely sure what that icon represents. In any case, I would take a look at the "Parent..." items. Work Items definitely seems to have a row per edit to an item, as I notice that I have several entries with nobody assigned and then one entry which is when I assigned an item to myself. Using "Parent User Stories | User Story" seemed to resolve the issue, it gave me the title to the user story and removed the duplicate rows once I unchecked "Title" in "Work Items".

skmcken's avatar
skmcken
Frequent Visitor
10 years ago

I get the same issue. If you look at the Work Item, you will notice its because of Version Changes. I haven't been able to roll the data up yet to only show the latest Version however.