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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
PowerWhy
Helper III
Helper III

Desktop performance versus Service

Hello,

 

I have some visualisations that take about 50 seconds to load on desktop and about the same on Service. I was expecting Service (we have a premium workspace) to give a big performance uplift. Is it expected for there to be little performance difference beween desktop and Service, or do I need to configure the report/workspace differently?

 

Many thanks for your help,

 

CW

1 ACCEPTED SOLUTION
ibarrau
Super User
Super User

Hi. If you have a visual that is taking 50 seconds to load it doesn't matter if you have using the highest premium with ram, there is an issue in a measure or the visual. There are no additional configurations. I would strongly suggest to review with performance analyzer tool inside power bi desktop, which visual is the one that is taking the most time. It might be an issue of one visual taking time to prevent others to load. You can find many videos about performance analyzer.

I hope that helps,


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

View solution in original post

3 REPLIES 3
PowerWhy
Helper III
Helper III

Hi yes agree there is a DAX issue that needs to be investigated, but still surprised there was no performance gain on Service. Is this expected?

Hi @PowerWhy 

There are two ways of accessing Data for the visualisations which may have an impact on your visualisation's performance.

If you are using Direct Query, to an SQL or similar database, each Visualisation will run a SQL query to refresh the visual, each time it's loaded. If your SQL database server responds slowly it would result in the sort of performance issues you are experiencing.

The solution in this case is to change to "Import mode" where the data is cached inside the Datamodel, which will remove the lag on rendering visualisation. Or upgrade the SQL server to a faster machine.

In my experience most speed issues are initially because people use Direct Query but don't understand what it does. The number of SQL queries generated is high and their SQL server can't serve the data fast enough. In that case the speed issue would be the same whether it was Desktop or Service and irrespective of the licence or workspace type.

Hope this helps

Stuart

ibarrau
Super User
Super User

Hi. If you have a visual that is taking 50 seconds to load it doesn't matter if you have using the highest premium with ram, there is an issue in a measure or the visual. There are no additional configurations. I would strongly suggest to review with performance analyzer tool inside power bi desktop, which visual is the one that is taking the most time. It might be an issue of one visual taking time to prevent others to load. You can find many videos about performance analyzer.

I hope that helps,


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors