Why is Power BI SLOW 

To summarize: There is nothing wrong with the Card visual, it's your dashboard that is bad for using them. Bigger question is why can't MS be bothered to fix the woeful performance of the most simple visual component.

Hmm 🤔 i don't like the advice of reducing the visuals. PBI is a data visualization and analysis tool. Visuals are essential. This shouldn't be a problem.

This video rocks!!! I just reduced the number of visuals on my report using a matrix. Thanks!!!

Thanks a lot for this video! This video would realise my teammates how important are these aspects to optimise reports and help them approach in the right way going forward(which they are not following now).

Guys... this type of content is a differentiator from competitors. SOLID.

It seems like that now only updating is slow but also Power Bi on my Windows machine gets slower and slower ... that's ridiculous, I mean I have a few visuals but isn't it the key functionality of BI?

Fantastic, I think this is great. I love how to explain your videos

Good stuff as always Patrick :)

The SQLBI guys just did a great video on using the Cards with States visual to consolidate a lot of different card visuals using small multiples.

You are the MVP Patrick, great video

I've been watching loads of these videos thanks for the tips. Helped me a lot. I had a really slow dashboard, and realised my silly mistake after hours of trying to optimise. I was running multiple measures over a time period in a line chart. I didn't notice that I had set the axis up so that it was on date, and not hierarchy (Year Month). So the visualise was calculating the multiple measures 365 times over multiple visuals. Lots of ugly babies! Changed to hierarchy and drilled to month, calculating 12 times instead. No problem now.

Very interesting Patrick , thanks for all your videos , Could you show us how analyze Social Media data (Twiter, Facebook, Instagam, youtube , etc..) in PowerBI , How to connect and examples of the KPIs we can show

One thing that is a very hit to performance from what I have found is that some computer science graduates put NVARCHAR(MAX) as their datatype and from what I know, you cannot index on a column that has MAX in the parameter making Power BI populate KPI's much slower. Not only that, the automation mess with so many Stored Procedures doesn't help! You should try to always use JOIN's instead of Sub-Queries if at all possible, because SQL Server is optimized for JOIN's and try to use Common Table Expressions instead of Temp Tables to reduce clean-up. Best practices for SQL Server that helps Power BI from the back end for performance tuning!

very useful, thanks Patrick

Hi Patrick. What can we do about the report cosmetics? A matrix doesn't always looks good. And what if the cards need to show the same measure, but with different filters applied? A matrix doesn't work rigth? In special if we need to use a PBIRS version prior May 2020 that doesn't include calculation groups. Thank you as always.

Hey Patrick, my power bi DESKTOP is slow and I suspect it’s my virtual machine. What’s the recommended cpu clocks for PBID so I don’t feel lag when I click on any buttons?

Great help saving my office time. Love ya! Lol

Great video! One thing we have noticed as as cause for our slow dashboards/visuals is sequential execution for subqueries for individual visualization with direct query against bigquery. In those cases the final time for the visualization will be a sum of all individual subqueries. I was wondering if there is a way the engine would pass those subqueries in parallel. Anyone has the same experience?

I think this is always a good reminder for developers!

Patrick, agree to your suggestions in theory but this is not always practical or even acceptable to our designers and end-users. Our designers really want to have customized KPI cards, chart components, and other UI stuff to achieve a great look and feel, which does required a lot of visuals . I have been pushed back that Power BI cannot achieve the look and feel of designs expected when trying to use tricks to reduce visuals - and the only way to do that is to have a lot of components (visuals, images, buttons, etc.). You combined 4 KPIs to 1 matrix. To get a good looking KPI card (with icon) - one sometimes needs 4 different components (KPI card, image/icon, bar chart for trend & text box for custom header placement). So 4 KPIs would be 16 components!!! This is one reason I limit the use of bookmarks too (adds a lot of visuals). So this example is great for show and tell, but in reality a great looking baby (oops report) a lot of times needs the high number of visuals/components. Agree with the other points, but again you cannot always expose your underlying data model as is (especially if you are going to allow end-users to use Q&A and/or personalize visuals)

A little torn abt this video. Reducing visial for a product whose purpose is to provide visualization feels...off. Reports arent just displayed on PBIS and user monitors, the reason for compact visual pages is for overview meetings in conf rooms.

What do you use for the animations? They're nice and fast.

Hi Patrick, Can we set up a different colour for a visual when it is still buffering and not fully loaded?

Can we use azure appid and client secret in Power BI ?? To configure datasources??

Great video. I'd be interested in two additional "flip the script" style videos like this one: Why is my Power BI file so large?, and Why is Power BI Desktop So Resource Intensive? I'm thinking of 350-400+ mb pbix files, and those times you have a report open in PBI Desktop and your machine sounds like it's about to take off. The solutions are likely related to the "triplets" you've outlined here, but even with star schema, etc. these two can happen, I think.

Hi Patric, Can you please resolve the following issue, I am trying the Matrix table column size increase based on the quarter I choose. For example if I choose three quarters I want to utilize the screen real estate properly.

Please what's the spec of your machine especially ram?

If everything else fails you might need a calculated table where all heavy lifting calculation has been already done. But use this only as a last resource thing.

Not to create too visuals in a visualisation tool? Why even call it a visualisation tool then?

Might need some help on Ugly DAX, I have a Fact table that has a lot of category's with another column that is called total. I want to do DAX to calc the total only on category_id = 100015 My current DAX is Total Revenue = SUMX('MyTable', if(MyTable[category_id == 100015, calculate(SUM(MyTable[total])), Black() ) ) Any help on a better way to this let me know looking for performance side note category_id and total are on the same table

Hi! I have a different speed problem. My report grew quite big over time, and now every modifying step takes minutes. For ex if I add a new column in a table, I press new column and I get the message "Working on it" with the spinning thing in front of it for about 3-4 minutes, then I type in the code for the new column, press enter, and again, working on it for 3-4 minutes. Same thing if I press Enter data to add manually a very small table, same thing with everything, every modification, deletion, adding in the data. The visuals are not affected, I can add / remove as many data as I want in the visuals without this delay. I checked with the performance analyzer, in total it's between 10 and 20 seconds, which is a lot but still pretty far from 2x4 minutes. Where is the problem and how can I fix it? Thanks!

how is he doing the filter bar on the left?

Let's not even talk about the babies...opening the program itself initially without a report...is slow :(

Cards really need development to collect into a single visual and other options for devs as they really are a slow spot.

Patrick, how can I get you to take a look at my Power BI report and help me 1:1 ? I have one visual on the page which is REALLY slow, and all it is is a graph of 3 measures over time. Other visuals using the same measures are not slow. Only the graph showing history and future (+/- 10 years) is slow.

Patrick, my data is huge like I have around 375M records. even though I optimize DAX and reduce the visual. still it is slow. Is there any solution you can suggest?

using single report as dashboard better or creating multiple reports and using them for dashboard - which is better use case? your videos are super.Thanks.

Hy Patrick, Everytime requirement is not so simple and stright forward. So reducing the visual will not help much.

Hey, come on, 7 visuals on a single page is too much? What is this, single threading?

Interesting… As a newbie I come here to solve my issue with Azure Cost Management report running for more than 2 (TWO!) hours. 😕

Power BI is just more fancy excel TBH, it doesn't scale very well on large datasets or more complex logic with dozen of variables. In our company we switched to preprocessed and denormalized tables in Greenplum and from there we push to PBI where we are having just bunch of filters, no logic, otherwise it will be hell slow

Babies are never ugly

Hi I am facing slow performance in matrix to laod

Yes, in Star schema, how do we handle dimensions with hundreds of millions? History Refresh fails with concurrency limits of dwh., No problem with incremental refresh though.

Cool video! I like the whatsapp conversation! "You don't want to see my data model"; " You don't want to see my DAX". So funny. :) Btw, I think that six cards plus one matrix is acceptable in most cases, when you have modified the data model and DAX. Wondering if you have tested the result with the first not-so-ugly baby kept?

Ngl I'd rather keep my aesthetics and have a slower report :)

These videos are getting a little spicy! 4:37

Truth! :D

Another great video Patrick! However I was TOTALLY distracted and excited that there may be a LEGO theme for Teams?! Does such a thing exist?! My Google skills tell me not - BOO :(

👍

is it possible to create starschema always?

If you have to dive into data modeling it's not self-service bi.

Im talking about just running it. Just running. Its so slow.

My babies are beautiful in my eyes ,but they might look different in others eyes.

Patrick. I need you to rate my babies? How can I do that?? 👨🏽‍🍼

Patrick, why is Power BI SLOW?

Your table has more than 1 BILLION rows hahaha look at that in 6:15: at the bottom-left you can see 1,034,769,900 rows

And you didn't even touch upon things like AvailableInMDX, making sure your keys are text and all the fun things you can do.

The 1st&2nd babies are understandable but 3rd baby. It seems to study more to get better DAX to get rid of this ugly one

No, I dont buy in to this at all. The whole app and everything about it is hideously slow. Loading Power BI is slow, the report designer is slow as hell. Dragging components is slow, changing data is slow, the workflow is hideous. Everything about Power BI is horrifically slow.

No ugly babies for this guy bcoz of you😀