Appending Data

[DannyAlfa]

Morning,

I need a bit of help, I have a xlsx dataset that I use for my power BI report, this dataset has now reached maximum rows so i need to create a 2nd dataset with the exact same columns. I have been trying to append queries using my Main Dataset and appending the 2nd file to this, it doesnt seem to be throwing any error at me but the data volume isnt changing so i know its not picking up the 2nd dataset.

I also have measures that I have created in the core dataset and need these to carry over if thats possible.

Im either: -

A - Doing it completely wrong

B - Doing it completely wrong 🙂

Any help would be much appreciated.

[Idrissshatila]

Hello @DannyAlfa ,

I assume that there's some filters maybe a date filter that is selected to the max of the date of sheet 1 and that's why the volume is not changing.

[danextian]

Hi @DannyAlfa ,

Assuming that there are no filters in the filter pane that ignores the second sheet and it is not in the data view either, prior to loading, I would check whether the second sheet  is actually there. You can change the order of the append by modifying the Append Query step which should be something like Table.Combine({PreviousStep, OtherQuery}). You can reverse the order.  After that,  I would go through each applied step after to check if there are succeding ones that ignore the second sheet.