Forum Discussion

Barkop_1's avatar
Barkop_1
Frequent Visitor
3 years ago
Solved

Power Bi performance - Desktop Vs Published Workspace

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's avatar
    aj1973
    3 years ago

    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

6 Replies

  • aj1973's avatar
    aj1973
    Community Champion

    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's avatar
      Barkop_1
      Frequent Visitor

      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's avatar
        aj1973
        Community Champion

        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