Forum Discussion
Maximum size for .pbix files
- 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
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
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