Power Bi performance - Desktop Vs Published Workspace

[Barkop_1]

Hello,

I an wondering about something.

I have Power Bi desktop with big amount of data (300 000 000 rows). Unless i filter something out, visualisations go out of resorces to re-calculate and show the results.

Do I understand it correctly, that this is connected with my hardware? So if i had more RAM installed on my laptop, than there is a chance that visualisations might just show correct numbers? 

How would it work if i were to publish this power bi workbook on some workspace? Would visualisations work beeing online, not dependent to my laptop?

[aj1973]

Hi @Barkop_1 

For sure more RAM better performance of Power BI Desktop.

In the service same thing and that's what makes the difference between Shared Capacity WS and Premium Capacity 

[Barkop_1]

What do you mean "In the service same thing"?.

Does it mean that even though I published report on services and open it via browser (shot down my desktop app) its performance will still be dependent on my laptops RAM memory?

Because intuitively i would assume that the calculations in this case would depend on some services resources + my internet connection (meaning calculations are being done elsewhere and I just get the result to my browser via internet connection).

[aj1973]

In the Service = Power BI Service. Once you publish the report to the service, Memory, Calculations, Performance... all taken over by the SaaS (Power BI Service). Your Desktop will have no effect on the reports 

[Barkop_1]

Ok so I understand that even thought my visualisations do not load on my laptop, they might work when published on Power BI Service (depending also on whether i have Shared Capacity WS or Premium Capacity). Unfortunatelly I can not check it yet.

But what if the visualisations don't show up even when published on Premium Capacity?

And my table is as simple as it can be (its simple but huge, and it has to stay this way, to proberly count distinct IDs and averages values), and my dax measures are simple as thay can be.

What would be the next step to asure that my users will be able to see the resoults in the published report?

[aj1973]

Also, please try Direct Query mode connection, it might be a solution for your visual.

[aj1973 · Accepted solution]

Luckily Power BI can handle billions of records and the visual will always show. What should be done though is to optimize your visual in desktop before going to service. There are many technical ways to do that including raising your RAM. But before going premium you need to watch this video to better make decisions

https://www.youtube.com/watch?v=ipdMRPdXcWA