Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
90 | |
87 | |
84 | |
68 | |
49 |
User | Count |
---|---|
131 | |
111 | |
96 | |
71 | |
67 |