Forum Discussion
Problem with many Fact Sales tables
Hi
In this case,
- FY: September- August.
- Every FY has a new Sales table.
- 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?
- Do I need to combine all the sales tables to only one Sales table?
- To the nr 3 above, what should I handle or save the Sales table form in the future?
- 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
3 Replies
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
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
