Forum Discussion

Sudhakar510's avatar
Sudhakar510
Icon for Helper I rankHelper I
3 years ago
Solved

Power BI Ram Usage

Hi Experts,   Currently we using Power BI Reporting Server Via Citrix and it has 32 GB. We using Direct query and performance is very slow. So when we convert to Import, it hits RAM and its like 80...
  • Shahfaisal's avatar
    Shahfaisal
    3 years ago

    Sudhakar510 wrote:

    Hi Shahfaisal ,

    Regards to Point 3, So in Service, after we publish and while refreshing, it uses Server Memory?

    But (After Import) when user starts to use the report it won't use server memory but it does use Power BI Service's Memory?  Correct? Please confirm me. I think this is the main point I am trying to understand.

     


    If you are using Power BI Service with import mode, DURING the refresh process, the local server's resources (memory, etc.) will be used to extract the data. AFTER the refresh finishes, users connect to the model in Power BI Service (all the data sits in Power BI service) so users won't be touching the local server.

    When users interact with reports/dashboards, they will be querying the model in Power BI service and are completely disconnected from the local server (meaning local server resources such as memory, CPU, won't be consumed).