Manage Fact tables size

Power Query Data Setup
1

Hi everyone,
I have a situation and I would like to ask for suggestions. I have a fact excel table imported to my model which is getting out of control.
I have data since 2017 and I have to keep feeding this on a weekly basis. I am sort of exploring alternatives, perhaps use a free data management program or split my fact table and merged it on BI…not sure which step to take. Can you guys please share some advice?

Thank you,

2

Hi @GCOSTA, have you looked into Aggregations?..

3

Hi @marcster_uk, thanks. Its really interesting, but not quite what I am looking for. What I am trying to do is to reduce my excel file size. Is it possible to get a fact table and save in BI “cloud” and feed this new table?

Thank you so much,

4

Hi, Gabriel! Which size has your excel file? Also, check the link https://docs.microsoft.com/en-us/power-bi/reduce-the-size-of-an-excel-workbook

5

Question. Do you have to store all your data in one Excel file?
Consider the “From Folder” option and Append the files in Power Query

6

Hi @GCOSTA, we’ve noticed that no response has been received from you since the 26th of March. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the checkbox. Thanks!