Forum Discussion

RobertG's avatar
RobertG
Regular Visitor
9 years ago

Column 'SETTLEMENTTS' in Table 'MM_SETTLEMENTTIME' contains a duplicate value '〲㘱㠰㄰ㄭ'

I have a dataset that randomly produces this error message on a schedu;ed refresh

"

An error occurred while processing the data in the dataset.

Column 'SETTLEMENTTS' in Table 'MM_SETTLEMENTTIME' contains a duplicate value '〲㘱㠰㄰ㄭ' 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."

 

The value is garbage and there are no duplicate values in the data.

The data come from an Oracle data source via a on-prem gateway.

Sometimes the query works, sometimes it doesn't - quite frustrating.

 

The column SETTLEMENTTS is constructed from a string contanentaton:

to_char((trunc(localtime)),'yyyymmdd')||'-'||to_char(period) SETTLEMENTTS

Data Modeling

1 Reply

  • v-haibl-msft's avatar
    v-haibl-msft
    Microsoft Employee
    9 years ago

    RobertG

     

    Table1 (many) and Table2 (one) have a many-to-one relationship, if dataset is updated and duplicated values exist in the primary key column. Above error message will be displayed.

    When you get this error message, can you get the same error in Power BI Desktop (Open the .pbix file and click Refresh)? If yes, you can create a calculated column with following formula to check which value has duplicates.

     

    Best Regards,

    Herbert