Forum Discussion
Dataset Help
Hi,
I have a working Power BI report where my xlsx file has now reached the manximum rows, what is the best way to create a 2nd data table to then merge if that is possible.
Also when I merge I have measures/rules etc created in the original dataset which would ned to remain.
Can anyone help
Hi DannyAlfa
I think you will want to use the Append setting.
This lets you take two tables with the same Columns but different Rows and stack them.
There is also a Folder data option which will automatically Append all files in the same folder together. You will need to filter to the same data type (i.e csv and xlsx cant be done together).
Would it be possibel to switch from Xlsx files to Csv? They can hold more than 1 million rows.
If Excel is your main data I understand this may not be possible.
3 Replies
SamWiseOwl I have tried to append and it seems to work with no errors but my data is refreshing, also to another point my core data set has measures built within it, should these carry over???
They should do!
Hi DannyAlfa
I think you will want to use the Append setting.
This lets you take two tables with the same Columns but different Rows and stack them.
There is also a Folder data option which will automatically Append all files in the same folder together. You will need to filter to the same data type (i.e csv and xlsx cant be done together).
Would it be possibel to switch from Xlsx files to Csv? They can hold more than 1 million rows.
If Excel is your main data I understand this may not be possible.
