Forum Discussion

sguenther's avatar
sguenther
Advocate II
10 years ago
Solved

Maximum size for .pbix files

Hey everybody,

 

so I created a report by querying data from our PostgreSQL server. It's quite a bit of data, so the file size is above the 250 mb limit and I can't upload it to the online dashboard.

 

Is there any way to remove the data from the pbix file in order to be able to upload it and then let the data refresh only online? Otherwise this would mean that PowerBI could not be used for larger data sets.

 

Best

Seb

Need Help
  • Bjoern's avatar
    Bjoern
    10 years ago

    Have you tried using the direct connect instead of the "import all"? ;-)

     

    Perhaps make sense. 250mb of a file is not really scalable. You will hit that limit in the long-run anyway.

     

    I would recommend:

    a) using live connect with on prem sql

    b) using live connect with azure sql db

    c) using an AS tabular model on top of sql db

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Do you need to load every single column?

    You can (should) remove columns that you are not using to reduce the size of the data in the model.

     

    This can be done through the Queries part (a.k.a. Power Query) and it can be done from the data model too (a.k.a. Power Pivot).

     

    Regards

    Sacha

     

    • sguenther's avatar
      sguenther
      Advocate II
      10 years ago

      Hey,

       

      I removed all the columns I don't need. But there are more then 12 Million rows. And I need all of them. No posibility to scale down the data model any more.

       

      There must be a different solution.

      • amien's avatar
        amien
        Helper V
        10 years ago

        Besides optimizing the pbix file i don't know anyway to make a 250+mb datamodel fit in the 250mb data limit.

        Only by putting the data in SSAS, which is most of the time no option. Or run it on-premisis when running on SSRS is possible.

         

        I hope they will upgrade this soon, or make it possible to pay for an upgrade.