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 this error that has started
Column 'Money to / From…?' in Table 'ADF2' contains blank values 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.
From this data, I am pretty sure it is in relation to rows 8 & 9 but this data is unique.
FE | Matter No | Clients Name | Money to / From…? | Description of Monies Received | Expected In £ | To Send Out £ | Date Expected |
MAJ004-0001 | Maj | Santander | advance | £73,415.00 | 23-Feb-17 | ||
MAJ 004 0001 | MAJ | Direction Law | purchase | £91,500.00 | 24-Feb-17 | ||
MEE015-0003 | Meek | MR& MRS MEEK | CGT a/c payment | £127,552.60 | 20-Feb-17 | ||
CRA112-0001 | Craig | client | bal due | £379,234.80 | |||
CRA112-0001 | Craig | Thackray Williams | purchase | £369,139.80 | 24-Feb-17 | ||
WAK016-0001 | Wakeford & Waghorn | client | bal due | £73.15 | |||
WAK016-0001 | Wakeford & Waghorn | Santander | advance | £108,765.00 | 22-Feb-17 | ||
WAK016-0001 | Wakeford & Waghorn | Help to buy ISA | HTB Isa | £900.31 | |||
WAK016-0001 | Wakeford & Waghorn | Help to buy ISA | HTB Isa | £925.10 | |||
WAK016-0001 | Wakeford & Waghorn | Sharratts | staircasing and apportionments | £37,278.56 | 23-Feb-17 | ||
WAK016-0001 | Wakeford & Waghorn | Anthony Stockton | purchase | £91,250.00 | 23-Feb-17 | ||
COO205-0002 | Cooley | O'Neill patient | sale | £229,500.00 | 23-Feb-17 | ||
COO205-0001 | Cooley | Nationwide | advance | £125,000.00 | 22-Feb-17 | ||
COO205-0001 | Cooley | Keystone Law | purchase | £378,000.00 | 23-Feb-17 | ||
COO205-0001 | Cooley | client | bal due | £14,541.00 |
Is there any way to stop this error?
Hi @krisso,
Which error did you get? To create a Many-to- one relationship, at least one column in one of the tables must contain unique values. For more information, see: Create and manage relationships in Power BI Desktop.
Best Regards,
Qiuyun Yu
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 | |
100 | |
77 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |