What is best practice to deal with missing data according to Kimball ?

[Allagowf]

I have a data base with the following tables:

Customers, Invoices, Salesman, Target.

The ones concerned about my question are Customers, Invoices.

There are customersIDs used in the Invoices but doesn't exist in the Customers table.

If I used only the customers from Customers Table, my customer dimension would be incomplete.

My solution is to append these IDs from Invoices to Customers and fill other columns in the Customers table with nulls.
I don't know if this is the best approche according to Kimball?

also if it is a good solution, how I can add accompish it with Power bi desktop ?

Customers table: "generated Data"

Customer ID	Customer	Contact	CustomerAddress
70	Customer 1	Contact 1	CustomerAddress 1
76	Customer 2	Contact 2	CustomerAddress 2
84	Customer 3	Contact 3	CustomerAddress 3
18	Customer 4	Contact 4	CustomerAddress 4
10	Customer 5	Contact 5	CustomerAddress 5
86	Customer 6	Contact 6	CustomerAddress 6
79	Customer 7	Contact 7	CustomerAddress 7
56	Customer 8	Contact 8	CustomerAddress 8
45	Customer 9	Contact 9	CustomerAddress 9
82	Customer 10	Contact 10	CustomerAddress 10
37	Customer 11	Contact 11	CustomerAddress 11
23	Customer 12	Contact 12	CustomerAddress 12
74	Customer 13	Contact 13	CustomerAddress 13
21	Customer 14	Contact 14	CustomerAddress 14
61	Customer 15	Contact 15	CustomerAddress 15
67	Customer 16	Contact 16	CustomerAddress 16
88	Customer 17	Contact 17	CustomerAddress 17
14	Customer 18	Contact 18	CustomerAddress 18
51	Customer 19	Contact 19	CustomerAddress 19
50	Customer 20	Contact 20	CustomerAddress 20
80	Customer 21	Contact 21	CustomerAddress 21

Invoice table:

InvoiceID	ProductID	Product	CustomerID	Salesman ID	Invoice Date	Amount	Cost	Quantity
10440	61	AAA Running Shoe	37	3	7-Mar-07	2685.83	1933.79	90
10455	61	AAA Running Shoe	80	1	21-Apr-07	668.75	553.73	25
10504	61	AAA Running Shoe	89	9	8-Jun-07	650.5	538.61	25
10530	61	AAA Running Shoe	59	4	5-Dec-07	554.2	448.9	20
10418	61	AAA Running Shoe	63	7	14-Jan-08	388.8	321.93	16
10716	61	AAA Running Shoe	64	2	20-Apr-08	255.7	207.12	10
10595	61	AAA Running Shoe	79	7	6-Jul-08	3897	2525.26	120
10642	61	AAA Running Shoe	73	3	18-Aug-08	643.92	434.65	20
10550	61	AAA Running Shoe	30	4	24-Oct-08	282.15	207.76	10
10724	61	AAA Running Shoe	51	1	26-Oct-08	134.1	108.62	5
10735	61	AAA Running Shoe	17	7	6-Nov-08	570.46	420.07	20
10769	61	AAA Running Shoe	19	3	4-Dec-08	542.2	439.18	20
10814	61	AAA Running Shoe	84	4	1-Jan-09	936.68	659.75	30
10880	61	AAA Running Shoe	24	7	6-Feb-09	973.08	715.21	30
10933	61	AAA Running Shoe	19	3	3-Mar-09	764.7	674.47	30
10990	61	AAA Running Shoe	1	8	29-Mar-09	2132.03	1635.18	66
10998	61	AAA Running Shoe	91	8	31-Mar-09	203.77	192.91	7
11034	61	AAA Running Shoe	37	9	17-Apr-09	145.56	128.38	6
11042	61	AAA Running Shoe	59	5	19-Apr-09	114.16	100.69	4
11058	61	AAA Running Shoe	6	7	26-Apr-09	107.88	95.15	4

..... just a sample the table is thousands of rows.

[Mahesh0016]

@Allagowf Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.