Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! 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