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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Azure Active Directory Activity Logs Content Pack Duplicate Value

I receive the attached error when importing data.  The content pack use to work fine.  Now it appears to be broken.  

PBI_AzureADLogs03.PNG("Column 'Unique ID' in Table 'Signin Activity' contains duplicate value...)

Status: Accepted
Comments
v-qiuyu-msft
Community Support

Hi @webermi,

 

The issue has been reported internally: CRI 38825146. Will update to you once get information.

 

Best Regards,
Qiuyun Yu

Vicky_Song
Impactful Individual
Status changed to: Accepted
 
San
Regular Visitor

We are also facing same issue. Do we need to report additional case?

San
Regular Visitor

Capture.PNG

San
Regular Visitor

Thanks @Microsoft team. It has resolved for me.

 

Report is really nice & useful from security point of view.

Anonymous
Not applicable

I'm now getting the same thing:

 

Something went wrong
There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.
Data source errorColumn 'Details.Unique ID' in Table 'Unique Users' contains a duplicate value '458300fe-a86c-477a-81f7-ba043cc78f01' 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. Table: Unique Users.
Cluster URIWABI-SOUTH-EAST-ASIA-redirect.analysis.windows.net
Activity IDa0cf852d-533e-4ec9-8ee8-d5def2894c50
Request ID128e332a-3950-593b-94f9-8251ac09cda5
Time2018-10-07 20:16:40Z
 
It seems to alternate between the 'Unique Users' table and the 'Signin Activity' table.
 
Thanks
Craig