Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
I have read about the benefits of Large dataset storage format and I'm in Premium Capacity so I can switch to that. My issue is when I'm opening the PowerBI reports (there are also others who reported this), it takes 2-4 minutes to load the report. We have more than 10 reports in the workspace and our data is 3 years only (though millions of records). So I'm thinking deeply if we have to switch from small to large dataset in PowerBI service and if this could help our issue. BUT my only hesitation is the limitation I read on this:
Download to Power BI Desktop: If a dataset is stored on Premium Files, downloading as a .pbix file will fail.
Large datasets in Power BI Premium - Power BI | Microsoft Docs
We still need to download pbix because we sometimes make changes on the report.
Can someone provide inputs and feedback on this?
Solved! Go to Solution.
Don't worry, you can always switch between large dataset to small dataset.
If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!
Don't worry, you can always switch between large dataset to small dataset.
If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 15 | |
| 14 | |
| 12 | |
| 11 | |
| 8 |
| User | Count |
|---|---|
| 40 | |
| 38 | |
| 29 | |
| 27 | |
| 22 |