Errors in VSTS integration

[MattLavallee]

Hi all --

We're using PowerBI with the VSTS service integration and last week we started getting an error during refresh:

Column 'Issue Id' in Table 'Parent Issues' contains blank values and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table.

We don't control the dataset and don't have any visibility into the rows causing the errors... anyone aware of a way of figuring this out?

Thanks,

Matt

[v-yuezhe-msft]

Hi @MattLavallee,

Could you please describe more details about that what changes you make in Visual Studio Team Services recently?  Would you please delete the dataset and re-connect the VSTS content pack, then check if you get any refresh errors?

Thanks,
Lydia Zhang

[MattLavallee]

Hi Lydia,

We actively use VSTS, so it's an ambiguous question to ask what we have changed... We obviously cannot change the data model ourselves as it is a service from Microsoft.

I can't delete the dataset because that will delete all of our reports and dashboards.

Thanks,

Matt