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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Mandalorian
Frequent Visitor

Power BI desktop file taking hours to open

I am working on a large dashboard for my team, about 878 MB. This file takes hours to open, even when using an ethernet connection.

For some context, I work remotely, but internet speed tends to be quick. When I go into the office this file will open within seconds. 

How do I make this easier to open? Is there any best practices you have when using larger files?

1 ACCEPTED SOLUTION
djurecicK2
Super User
Super User

Hi @Mandalorian ,

 Are you able to copy the file to your local machine, then work on it there, then copy back or publish once you have finished? You might also consider editing the report inside the PBI service once it is published.

View solution in original post

9 REPLIES 9
aj1973
Community Champion
Community Champion

@Mandalorian 

Upgrade the RAM of your machine. Power BI desktop lately needs at least 16 GB of RAM to run smoothly.

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

I have 32 GB of RAM on my laptop. It is only 2 years old.

You said you work remotly, on which machine you are trying to open the Power BI desktop of your report?

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

cassidy
Impactful Individual
Impactful Individual

Are you saying it's already downloaded and available on a drive and then opening it takes hours?

 

Or the download from Service takes hours?

 

If it's already downloaded, Internet speed should not be related, only available computer resources.  Refreshing the file in Desktop is where Internet comes back into play.  Is your remote machine the same as your office machine?

It is saved on the shared company drive. Opening the file from the shared drive takes hours. I am using a laptop with 32 GBs of RAM. It opens faster when I am in the office and using ethernet. 

cassidy
Impactful Individual
Impactful Individual

I'm not a network expert, but I don't think it's a Power BI issue based on that, talk to you IT and see if there is a bottleneck around your VPN or something.

When you say shared drive, I'm assuming it's hosted by your company and not SharePoint (if SharePoint, the download shouldn't be limited by anything except your network).

You got your answer then

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

djurecicK2
Super User
Super User

Hi @Mandalorian ,

 Are you able to copy the file to your local machine, then work on it there, then copy back or publish once you have finished? You might also consider editing the report inside the PBI service once it is published.

Copying to my local machine still takes a while, but might be my best option. I am working on this with another analyst so it's easier to use the network. 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors