One of the significant advantages of Power BI's Pivot data modeling engine is an especially performant columnar database, the usage of modern tabular database applied sciences to compress databases and make sure they load entirely into reminiscence for the exceptional viable performance.