PowerBI basics, dataset size on disk, in memory.

Hey sci66 ,

there are just 2 options with Premium. Either your company is using a premium capacity, what starts at 4'995 USD per month. Or you take a Premium per User License what is 20 USD per month per user. This is then including the Pro license (10 USD). So you pay 20 USD instead of 10 USD.

Concerning your questions:

1. The size of your .PBIX file

2. Open DAX Studio and connect it to your PBIX file. Go to Advanced --> View Metrics and then to the summary tab. There you see the size in the RAM:

3. Once the model is loaded the RAM doesn't change much.

4a. That depends very much on your data. If the values in your data is repeated many times, the compression is higher. For monitoring reports, where the same error messages appear again and again the compression can easily be 30-60 x. If you prepare your data in a bad way, e.g. keep transactions with milliseconds, there will not be a big aggregation, so not a big compression. Microsoft once said in average the compression is 15x. But as I said that depends very much on your data and the way you prepare the data.

4b. Open them once in a while, then the reports and dashboards are in the cache.

5. As said at the beginning, there is just premium for the whole company or premium per user. Then the datasets can become 100GB and above.