Showing results for 
Search instead for 
Did you mean: 
New Member

Errors in VSTS integration

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?





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?

Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.




Helpful resources

Join Arun Ulag at MPPC23

Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors
Top Kudoed Authors