Forum Discussion
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 tables in Power BI and how do I build relationships with all dimension tables?
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-queriesIf solved your requirement, please mark this answer as SOLUTION.
If this comment helps you, appreciate your KUDOS
Thanks
Pijush
3 Replies
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-queriesIf solved your requirement, please mark this answer as SOLUTION.
If this comment helps you, appreciate your KUDOS
Thanks
PijushHello, 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.
Hi dr_anas
Sure
Please share some additional information
Sheet 1 - No of Rows, No of Columns, Name of Columns
Sheet 2 - No of Rows, No of Columns, Name of Columns
After Append the sheet, did you turn off Enable Load for Sheet 1 and Sheet 2
Refer - https://www.purplefrogsystems.com/2021/04/power-bi-enable-load/
Let me knknow
