Forum Discussion
PowerBI battering the database
Our database is a fairly low-powered Azure instance that houses a large amount of data and has one chief summarizing query in a stored procedure that takes anywhere between 30s and 2 minutes to compl...
In the end with this one we just added another table to the DB into which the calc'd results from the sproc were stored, and made PBI work from the cached data. It's imposed minorly more work in keeping the summary sync'd with the data that generates it but at least it meant the PBI team could get on with stuff at a reasonable pace