Data Modeling

[dr_anas]

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?

[PijushRoy · Accepted solution]

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]

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.

[PijushRoy]

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