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.
Hi everyone!
I'm trying to append the tables 'Inventory' and 'Intransit'. These tables both have column "Date". When I clicked apply, this message shows up.
Shouldn't PowerBI append the data based on columns? When there are columns with the same name, it should be stacked on top of each other right?
The table "Product" doesn't even have a date column. Could someone tell me why I got this error and how to fix it?
Thank you!
Solved! Go to Solution.
Hi @LinhNguyen ,
please give an overview of your Power Query Steps.
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
Hi @mwegener ,
My steps are as below:
Append Inventory 1010-1020; Inventory 1510-1610; Inventory 3010-3610 into Inventory
Append In transit 1010-1020; Intransit 1510-3010; In transit remaining into In-Transit
Then append Inventory and Intransit
Hi @LinhNguyen ,
please a full screenshot from the Inventory Query.
I want to see the columns and the applied steps.
Like this?
Hi @LinhNguyen,
Unfortunately, I do not see the problem.
Can you refresh the Power Query preview without errors?
Hi @LinhNguyen ,
crazy!
I would try to disable the load for both tables.
Refresh the model.
And load the table again.
Yes that's right.
Thank you so much!!!!!!!
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 |
---|---|
110 | |
97 | |
78 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |