Best practices to refresh a powerbi file in powerbi service?

[Anmolgan]

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?

[v-alq-msft]

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.

[camargos88]

Hi @Anmolgan 

Have you thought about incremental refresh ?

https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh

Ricardo

[Anmolgan]

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

[camargos88]

@Anmolgan ,

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

Ricardo