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.
How to ignore duplicate or null values in relation fields ?
I am not able to Refresh Data due to duplicate values exist on ID4 Field
check below image.
below are resilt from Scheduler:
SessionID: 07327ef1-3c8c-4d4f-89c2-4889198f7d3c [0] -1053425602: Column 'ID4' in Table 'AGTPRF_LND_HCHY' contains a duplicate value '93673' 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. [1] -1055784934: The command has been canceled.. The exception was raised by the IDataReader interface.
Note : The duplicate is not mistake .. but it`s nessary from bussiness logic prespectave
select * from AGTPRF_LND_HCHY where ID4=93673
Head of Department | ID | Manager | ID1 | UnitManager | ID2 | TeamLeader | ID3 | Name | ID4 | LAN |
Adam | 18828 | Yasmien | 19797 | Sara | 19797 | Samy | 19895 | Dimond | 93673 | 93673 |
Adam | 18828 | Yasmien | 18790 | Erik | 33568 | John | 33568 | Mark | 93673 | 493673 |
How to ignore duplicate or null values in relation fields ?
thx for response @Tahreem24
BUT this not what I asking for.
as I mentioned "The duplicate is not mistake .. but it`s nessary from bussiness logic prespectave"
Therfore : I want PBI refresh data regardles "duplicate , null " values.
anybody can advice ?
For more Clarefication:-
if I delete the duplicate it will be Report will have "Missing Data".
Therefore ; need to avoide "delete duplicate data" and PBI refresh data regardles "duplicate , null " values.
anybody can advice ?
Hi @Anonymous
As the error message said:
Column 'ID4' in Table 'AGTPRF_LND_HCHY' contains a duplicate value '93673' 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
Please recreate the relationship,
if table AGTPRF_LND_HCHY' use 'ID4' as a key to create a relationship with other tables, it should be many side instead of one side.
Besides, there are many errors when refreshing,
to check which causes the refresh failing,
edit the relationship as above, then see if the relationship or duplicate/null values causes the refresh error.
Similar threads about the odbc error:
https://community.powerbi.com/t5/Desktop/0x80040E4E-Error-OLE-DB-or-ODBC/td-p/116683
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |