Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get 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

Reply
Anmolgan
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?

4 REPLIES 4
v-alq-msft
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.

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
Community Champion
Community Champion

Hi @Anmolgan 

 

Have you thought about incremental refresh ?

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

 

Ricardo



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 ?

 

Ricardo



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

Proud to be a Super User!



Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.