Hi ALL,
Firstly GilbertQ thank you for your solution!
And @afaro ,After such a long period of time, has the problem you are experiencing been resolved, if you are experiencing errors like The key didn't match any rows in the table, it could be attributed to the following:
1. Missing or mismatched key values:
If you use a column as a join key in a Power Query (for example, when merging between tables), but some of the values in that column don't exist or don't have matching rows in the target table.
If you encounter this problem you can check to make sure that all referenced columns (such as the key column used for the join) have matching values in all the related tables.
2. Inconsistent data in the source table:
If you extract data from a Power BI data stream and some rows or columns of that data stream do not load properly as expected (for example, some columns or data are missing).
3. Inconsistent data types:
If the data type of a column does not match what is expected (for example, a column was originally of numeric type, but some of the rows in this column become text type)
You can rule out one by one according to your actual situation. I hope my suggestions will help you with your problem!
Hope it helps!
Best regards,
Community Support Team_ Tom Shen
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
