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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Abraxasnew
New Member

Power Bi Desktop takes very long to load reports

I have a few reports that have been working just fine until Friday.

Today (since morning), they take forever to load (some more than 30 minutes).

I tried a free install on a new machine, and I get the same behavior. Smaller ones load in 5-10 minutes.

 

If I try opening Power Bi by double-clicking on the report, it seems to remain at the "Initializing model" step.

 

Any idea what I can do?

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Abraxasnew , just check is after August 2020 update.

 

refer the issue faced in August 2020 - https://community.powerbi.com/t5/Issues/August-2020-version-of-PBI-Desktop-corrupts-any-PBIX-report-...

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

4 REPLIES 4
v-shex-msft
Community Support
Community Support

HI @Abraxasnew,

I'd like to suggest you check the backend query table codes to confirm if any complex or advanced operation added in your query steps. (e.g. merge, append, combine, reference, invoke custom function...)

If this is a case, you can consed adding buffer function to prevent the duplicate resource spend on looping calculations.

How and When to use List & Table Buffer? 

In addition, you can also take a look at below document about optimization tips about using power bi desktop:

Optimization guide for Power BI 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

I downloaded the July version from the first post, and it is working fine.

I will stick to it for now, and hopefully, MS fixes it in a future version...

 

amitchandak
Super User
Super User

@Abraxasnew , just check is after August 2020 update.

 

refer the issue faced in August 2020 - https://community.powerbi.com/t5/Issues/August-2020-version-of-PBI-Desktop-corrupts-any-PBIX-report-...

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Thanks! I already had 2.84.701 on both machines 😞 Seem that solved the problem from that thread. My fines seem to eventually open, but can't really work with files you have to wait like 45 minutes to load.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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