Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
DannyAlfa
Frequent Visitor

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

1 ACCEPTED SOLUTION
SamWiseOwl
Community Champion
Community Champion

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.

View solution in original post

3 REPLIES 3
DannyAlfa
Frequent Visitor

@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.

SamWiseOwl
Community Champion
Community Champion

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.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.