Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Problems with Azure Active Directoryy Preview

I am having an issue with the Azure Active Directory Preview. It was working fine up to last week but now I am getting the floowing error:

 

Data source errorColumn 'Details.Unique ID' in Table 'Unique Users' contains a duplicate value '6a094cee-605a-4a9a-924b-cf8f2c1b7c94_a672d62c-fc7b-4e81-a576-e60dc46e951d_201705251854_190.213.84.10_0' 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.
Activity IDb43d63f8-af24-1fd3-df21-fdfda65c4f95
Correlation IDdbd0183d-dd27-56ab-598e-b16a66783ff5
Request IDf5e8d080-8a1b-0386-6971-210824d2fedf
Status code400
TimeMon May 29 2017 14:09:10 GMT-0400 (SA Western Standard Time)
Version13.0.1700.2316
 
Can anyone help?
Status: New
Comments
v-haibl-msft
Employee

@dwilsontt

 

The error message says there are duplicate values in the Unique ID column and this is not allowed as this column is one end of a relationship. Power BI currently only supports foreign key to primary key relationships and the primary key side cannot have duplicate values.

 

You need to go to Unique Users table and check the Unique ID column.

 

Best Regards,
Herbert

dwilsontt
New Member

I'm not sure that I have access to the data in that way as it is a Microsoft Content Pack.