Forum Discussion

dr_anas's avatar
dr_anas
Frequent Visitor
2 years ago
Solved

Data Modeling

I have 2 Excel sheets containing sales data for 2022 and 2023 with rows in excess of 100,000. Is it possible to merge both, or would it be more bulky to handle? If not, am I able to create two fact t...
Need Help
Show and Tell
  • PijushRoy's avatar
    PijushRoy
    2 years ago

    Hi dr_anas 

    There are no challenges to Marge the two-table, if there are 500000 rows, you can append table and run the Power BI report smoothly
    Follow process - https://learn.microsoft.com/en-us/power-query/append-queries

    If solved your requirement, please mark this answer as SOLUTION.
    If this comment helps you, appreciate your KUDOS

    Thanks
    Pijush

PijushRoy's avatar
PijushRoy
Community Champion
2 years ago

Hi dr_anas 

There are no challenges to Marge the two-table, if there are 500000 rows, you can append table and run the Power BI report smoothly
Follow process - https://learn.microsoft.com/en-us/power-query/append-queries

If solved your requirement, please mark this answer as SOLUTION.
If this comment helps you, appreciate your KUDOS

Thanks
Pijush

dr_anas's avatar
dr_anas
Frequent Visitor
2 years ago

Hello, Pijush I followed your instructions and was able to combine two inquiries into a single new one, but it took too long to refresh because there were two original sheets. any additional guidance.