Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Solved! Go to Solution.
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.
If you are happy with this answer please mark as a solution for others to find !
Kudos are always appreciated! Check out our free Power BI video courses.
@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!
If you are happy with this answer please mark as a solution for others to find !
Kudos are always appreciated! Check out our free Power BI video courses.
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.
If you are happy with this answer please mark as a solution for others to find !
Kudos are always appreciated! Check out our free Power BI video courses.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
95 | |
91 | |
82 | |
69 |
User | Count |
---|---|
161 | |
127 | |
124 | |
108 | |
97 |