Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi Experts,
I am new to power Bi I would like to know I have table oinv and another table ORIN and ODPI , These 3 tables have the same docnumber so If I need to merge it and take a sales report , the system will show an error saying same Doc Number is there.
How can we rectify this
Solved! Go to Solution.
@thobenjo , If you have already imported them to power bi and if some column is missing it should error there?
Once tables are there you can append or merge Append : https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Can share error what you are getting - screenshots/details
Hi @thobenjo ,
What is the specific error message? Could you please provide a screenshot with the error? If it is possible , please provide your pbix file without privacy information.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@thobenjo , If you have already imported them to power bi and if some column is missing it should error there?
Once tables are there you can append or merge Append : https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Can share error what you are getting - screenshots/details
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 59 | |
| 43 | |
| 42 | |
| 23 | |
| 17 |
| User | Count |
|---|---|
| 190 | |
| 122 | |
| 96 | |
| 66 | |
| 47 |