Create stand alone of individual PBI file then combine all into 1 ?

[Paulyeo11]

Hi All

It is best practice for create all indivdiual PBI file. when successful then copy the power quary M code into one PBI file . This way of approach it is correct ? As i have about 10 sales order table , some CSV and some TXT format and CSV file their field name some are different. so it is better rename using M code and latest combine all into 1.

Paul

[amitchandak · Accepted solution]

@Paulyeo11 , Not very clear. You can merge them using the M code or option.

https://radacad.com/append-vs-merge-in-power-bi-and-power-query