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 to merge two tables that have a common column as Country-ID. I tried merging them by keeping the data type of the common column in both the tables, first as Whole Number and then as Text, but neither of them is working. I am getting the following error.
Solved! Go to Solution.
Hi @Ishi_garg
When Merging tables, it doesn't support to merge based on columns which have two kinds of data types.
Please change the type to the same one.
If you need to keep, you could create a duplicate column for that column, and change the type.
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.
dd
Hi @Ishi_garg
When Merging tables, it doesn't support to merge based on columns which have two kinds of data types.
Please change the type to the same one.
If you need to keep, you could create a duplicate column for that column, and change the type.
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.
dd
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 |
---|---|
101 | |
50 | |
19 | |
12 | |
11 |