Anonymous
I am sorry and don't mean for this to be rude but this isn't microsoft excel. PowerBi was made to handle the large data sets and to provide multiple years of data. I started with PowerBi when it first released and have multiple reports with 7+ years of analysis. If you truly believe you should only load six months of data into PowerBi you might want to up your expectations. Even if reducing the size of the model would cause some of the refresh failures to work, that should never happen. Microsoft should recognize there is an issue and fix it before it gets to that point.
That being said, more than half of my refresh failures came from my smallest data sets that only contained 5 days of data. Five Days of Data is a 674 KB model. It failed. My Employee parking report is a 140 KB model. It failed. My large model is 215,937 kb and it worked perfectly the entire time.
Please note, my refreshes have currently returned to normal with no changes on my end. This was entirely on Microsoft's side and has somewhat resolved until the next time it happens.