Solved: Data Modeling

dr_anas · ‎12-01-2023

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 · ‎12-01-2023

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

Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!

View solution in original post

PijushRoy · ‎12-01-2023

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

Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!

dr_anas · ‎12-01-2023

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 · ‎12-01-2023

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