Problem with many Fact Sales tables

[Aixia]

Hi

In this case,

1. FY: September- August.
2. Every FY has a new Sales table. 
3. Since there are several persons who has responsibility to update the table, so the sale table saved as form ´´ Sales_date_initials´´ which become many Sales tables related to every single FY. 

Since the Sales table will be the Fact table in Power BI, what shall do I before upload to PBI Desktop?

1. Do I need to combine all the sales tables to only one Sales table?
2. To the nr 3 above, what should I handle or save the Sales table form in the future? 
3. Is that possible to save all the Sales tables to the same folder and update at the same time?

Appreciate for all the tips and advice. Thanks.

Regards

Aixia

[Idrissshatila]

Hello @Aixia ,

It's better to combine all sales tables into one, you could do this in power query.

you could have all versions in a folder and connect with power bi using the folder connector and then combine the sales tables into one.

folder connector https://learn.microsoft.com/en-us/power-query/connectors/folder

combine all sales tables https://learn.microsoft.com/en-us/power-query/append-queries

[Aixia]

Hello @Idrissshatila 

Thanks for your quick reply. I´ll check the links & try to get some ideas. 

But I still don´t know how to handle the daily work routine regarding the question 2.

From your opinion I guess I need to combine the tables all the time, or? 

Do you have any idea how to use the fold funtion which has all of the tables in Power BI?

What I mean is that we can update the fold once there are new saved tables coming. In this way maybe we can solve the quesstion 2? 

Br/Aixia

[Idrissshatila · Accepted solution]

@Aixia ,

yes combine everything in one table.