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.
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 |
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |