Forum Discussion
SAP and Power BI
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
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
2 Replies
- amitchandak
Super User
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
- AnonymousNot applicable
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.