PPU license data model/ dataset size is 2GB pbix file and getting a warning message

[smjoshi]

Hello 

I'm using PPU license. I have below question

1. In my star schema model number of dimesions has million records . As dimesions has more data , datamodel/dataset has reached the size of 2GB pbix file. I'm using PPU license as per MS documenattion it says single datamodel/dataset size can be 100GB and our is just 2GB still I'm getting an error while opening pbix file using PBI desktop as below. In PBI desktop I see my name which shows option "view account" on right top profile and its not free user login 

[v-luwang-msft · Accepted solution]

Hi @smjoshi ,

As the official document said, if you've created a large model and the resulting protected .pbix file is very large (over 2GB), it may crash when you try to save or open it. To work around this, consider removing the protection from the .pbix file and re-applying it after the file has been published to the Power BI service.

For more information,you can refer to this :

Best Regards,

Lucien

[TomMartens]

Hey @smjoshi ,

even if a Premium Per User licensed workspace can host datasets that can become 100GB in size.

There is a limit to the file size (the pbix file) of 2GB.

You have to use incremental refresh as described here: Incremental refresh for datasets in Power BI - Power BI | Microsoft Docs and here: Advanced incremental refresh with the XMLA endpoint in Power BI - Power BI | Microsoft Docs

Hopefully, this provides some ideas on how to tackle your challenge.

Regards,

Tom