Microsoft demonstrated the ability for its Power BI business intelligence tool to query datasets with up to 1 trillion rows, up from its current threshold of 10 billion.

A Power BI report connects to a single dataset and will have at least one report page, but it can have many pages. In order to build reports in Power BI, the only thing you really need is data.

Premium users of Microsoft's Power BI service will see a huge increase in the size of dataset caches, allowing for 400GB of storage capacity as opposed to only 10GB being available previously.