One GB dataset limit and Power BI Premium

• Power BI Desktop files (.pbix) larger than 1 GB in size cannot be published to shared capacity in the Power BI service. However, with a Power BI Premium capacity provisioned (dedicated, isolated hardware), datasets up to 10GB in size are expected to be supported by October of 2017. Moreover, an incremental data refresh feature identified on the Power BI Premium whitepaper will likely make it possible to support much larger datasets in the future.
  • See Chapter 12 (Deploying and Distributing Power BI Content) for additional details on Power BI Premium.
• Scalability is one of the main drivers of migrating a Power BI model to a SQL Server Analysis Services (SSAS) instance. The model can be migrated to an on-premises SSAS tabular server or to Azure Analysis Services.
• In the absence of SSAS migration and any new partitioning or incremental data refresh feature available to Power BI models, it's important to design data models that compress well and only include essential columns and grains.