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 dashboar...
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

Anonymous's avatar
Anonymous
Not applicable
10 years ago

If you really need all the data and can't reduce/trim/dedupe/pre-agg then you are likely to need something like SSAS to store the data and use a live connection until/if they increase the limit.

 

SSAS might offer some addtional benefits to your scenario too.

 

[Update:  Have you looked at the data types you are using in the model?  Can you use a more efficient data types anywhere?] 

 

Sacha

 

Bjoern's avatar
Bjoern
Continued Contributor
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