Power BI — How to fit 200 million rows in less than 1GB!

Extraordinary tasks request extraordinary solutions. Check how to pack 200 million rows in 18 MB of Power BI.

Nikola Ilic
https://unsplash.com/photos/uu-Jw5SunYI
https://www.pexels.com/photo/macro-outdoors-perspective-rocky-268953/
https://unsplash.com/photos/_v0xhIT715g
Image by author
Image by author
Image by author
Image by author
Image by author
Image by author
Image by author
Image by author
Total Profit Hot & Cold = 
VAR vProfitHot = SUM(factBetSummaryHot[profit])
VAR vProfitCold = SUM(factBetSummaryCold[profit])
RETURN
vProfitHot + vProfitCold
Image by author
Time Line = 
VAR maxDate = CALCULATE(
MAX('factBetSummaryHot Agg'[datePlaced]),
ALL()
)
RETURN
EOMONTH(DATE(YEAR(maxDate),MONTH(maxDate)-3,1),0)
Total Profit = 
VAR vProfitHot = SUM(factBetSummaryHot[profit])
VAR vProfitCold = IF(
MIN(dimDate[date]) < [Time Line] ,
SUM(factBetSummaryCold[profit])
)
RETURN
vProfitHot + vProfitCold
Image by author
Image by author
SELECT datePlacedID
,SUM(profit) profit
,SUM(countBet) countBet
FROM factBetSummaryCold
GROUP BY datePlacedID
SELECT sportTypeID
,SUM(profit) profit
,SUM(countBet) countBet
FROM factBetSummaryCold
GROUP BY sportTypeID
Image by author
Image by author
Image by author
Image by author
Image by author
Favorite

Leave a Comment