Forum Discussion

Fowmy's avatar
Fowmy
Super User
4 years ago

Anonymous 

As of today Power, BI Pro only allows 1GB, you need to either switch to Premium which allows 10 GB, or change your connection to Direct Query. 

I wonder, what makes your files so big. have you tried to optimize the file by reducing tables and columns? This will help you optimize and reduce the file size.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Fowmy 

    Thanks for your quick reply

     

    If i moved to Premium x user, i will have 10gb in the limit of pbix?

    I can public with user premium per user and users that have pro can see this publication¿?

     

    I try to performance and delete fields that not user, but the main size increase when i bring historical data, for example i have all my 2021 data in my datamodel and this is 1.6 gb, if for example i add one month, each month increase 200mb my PBIX size

    Is there any way to reduce this?

    My select is very simple, only have 7 fields, and have 900.000 recods in a months, about 11 million x year.

    Is this a real limitation?

     

    Thanks Fernando.