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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Sept PBI Carousel

Power BI Monthly Update - September 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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