How to publish a file which is more than 1GB in Pro License when the client it not agreed for Premiu

[pbiforum123]

How to publish a file which is more than 1GB in Pro License when the client it not agreed for Premium license. How to handle the report in this scenario? 

[ibarrau · Accepted solution]

Hi. That is a limitation of PRO mode. The only alternatives that you can check are

- Downsizing the data model. You can do it with best practices or filtering the data. If you have 10 years of data, try reducing until it's ok for users.

- If your sources are able to use direct query, you can try a data model with Power Bi Aggregations. Create a composite model all imported with a reducen imported aggregated fact and another full history fact as direct query. You can read more about this if you google it. It's an approach.

I hope that helps,

[pbiforum123]

@ibarrau Thanks a lot for responding. Can you please share some link for Compsite model with practical example to understand better.

I basically wants to understand how to retrieve the summary data from imported fact and detail data from direct query which is from same report.

[ibarrau]

Sure. This is a reading for theory. The ways you can build the schema and scenarios.

https://dax.tips/2021/09/06/intro-to-power-bi-aggregations/

Then you have microsoft doc, directly to how it's built

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models

I hope that helps,