Showing results for 
Search instead for 
Did you mean: 
Post Prodigy
Post Prodigy

Best practices to refresh a powerbi file in powerbi service?

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?

Community Support
Community Support

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. 


Best Regards



If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Champion
Community Champion

Hi @Anmolgan 


Have you thought about incremental refresh ?



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

@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.

@Anmolgan ,


How is your datasource tables ? Is it normalized ?  No redundancy about columns ?



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors