cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Microsoft
Microsoft

Performance too slow of Desktop and published report

What might be the reason for my report to take > 10seconds to load on the powerbi site.

Also publishing the report takes about > 5min sometimes.

I have a small dataset with 1 table and about 300 rows but has about 100 columns.

Is the number of columns causing the performance degradation?

4 REPLIES 4
Highlighted
Community Champion
Community Champion

Number of rows and columns is obviously very small but that doesn't tell the whole story

 

How big is the file? Do you have columns that contain large amount of text/comments unnecessary for data analysis?

 

But it also sounds like an internet connection / speed issue?

 

what OS are you running?

 

From the posts I've read here seems few people not on Win 10 have performance issues...

Highlighted


@gjadal wrote:

 but has about 100 columns.

Is the number of columns causing the performance degradation?


Highly likely. Just test it. Create a copy, delete 90 columns and then load it up and see what happens. Wide tables are very problematic in power pivot. 



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Highlighted
New Member

I have the same problem, only since I downloaded the latest version of Power BI last week. Now it is taking at least 5-10 minutes to publish the data (not significantly different in size, and with fewer data points). Any suggestions as to how to fix this?

Highlighted

The same problem here.

 

My reports are now take very long time to publish, and i havn't changed much in the models.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors