Forum Discussion
SBC
Helper III
Helper IIIHow to efficiently load large dataset (>1GB) from source into Power BI
Hi Experts, I have a situation with my Power BI report: I can only select entire tables from the source (no option to write SQL queries or apply filters at the source level).After fetching the dat...
Don’t import full 1GB into Desktop — use Incremental Refresh with RangeStart/RangeEnd → Desktop loads only a slice, Service handles partitions.
Use Dataflows as a staging layer for heavy tables.
Keep recent data in detail, aggregate old data.
Optimize model (drop unused columns, use proper types).
If still too big → use Composite Model (Import recent + DirectQuery old).
Best option: Incremental Refresh + model optimization.
audreygerred
Super User
Super UserHello! Power BI typically handles large data great and the compression in import mode is amazing. What Fabric SKU do you have - that determines your size limitations. If you are just using pro, your model cannot exceed 1 GB. F64 is 25GB per model, F128 is 50GB per model, F256 is 100GB per model.