Speed up Power Query with List.Buffer. Cache lists, cut recalculation, and slash refresh times for large datasets in Excel and Power BI.

Microsoft's Power BI supplies a default date table that’s adequate for many time grouping requirements. Find out how to know if the Auto date table is adequate when using Power BI.

I’m using Power BI Desktop on a Windows 10 64-bit system, but you can also use Power BI Service. To follow along, download the demonstration .pbix file, and then, double-click to open it in ...