Forum Discussion
Appending Data
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 ...
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.