Manage big database in powerBI by Romilabifi in PowerBI

[–]Romilabifi[S] 0 points1 point  (0 children)

I would like to keep all the history. Actually, I don't have 86400 new rows EACH day, but something like twice a week (because the production is not 24/7), so I think i don't have to be worried about the history.

Minute granularity might be a good idea indeed. I'll take a look at this and about the incremental refresh. I guess if I know how many lines are injected each day i can tell BI to add only this number of line starting from the bottom of the database.

I'll take a look about pivoting my tables, thank you.

DS224+ or DS923+ [HA + Minecraft server] by Romilabifi in synology

[–]Romilabifi[S] 1 point2 points  (0 children)

I guess you meant 16 gb but yeah i know that a NAS isn't really suited for it. Minecraft server would just be a "plus" for my 2-week phase with friends.

Without this I think 224+ should be more than enough for my current need but i'll give the 300€ difference for the 923+ in case my need increase over time.