Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi I have a powerbi file that is close to 1 GB, am looking for the best practices in how can i successfully refresh this in the service with less amount of refesh time?
Hi, @Anmolgan
You may reduce the amount of data being imported to Power BI and try again.The maximum size for datasets imported into the Power BI service is 1 GB. These datasets are heavily compressed to ensure high performance. In addition, in shared capacity, the service places a limit on the amount of uncompressed data that is processed during refresh to 10 GB. This limit accounts for the compression, and therefore is much higher than 1 GB. Datasets in Power BI Premium are not subject to this limit.
For further optimization, I'd like to suggest you refer the following officical document.
https://docs.microsoft.com/en-us/power-bi/guidance/power-bi-optimization
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anmolgan
Have you thought about incremental refresh ?
https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh
Ricardo
@camargos88 I thought about it, but we are not opting for a premium capacity for now, I know there are some issues when setting up the same using pro license.
How is your datasource tables ? Is it normalized ? No redundancy about columns ?
Ricardo
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
105 | |
99 | |
98 | |
38 | |
37 |
User | Count |
---|---|
157 | |
120 | |
74 | |
72 | |
63 |