Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Refresh failed only online

Hi everyone, I got a problem with the scheduled refresh online. Severals reports can't be refresh online. The other ones are ok. No problem with desktop to refresh all of ones (use max 15Go/32Go m...
Need Help
  • zoloturu's avatar
    zoloturu
    8 years ago

    Anonymous,

     

    There is no fixed capacity per Pro user. That's why it is called SHARED. It depends on how much users are using Power BI Service with shared capacity. 

     

    As per my feeling usually, it is around 3-5 GB.

     

    1. Remove not used columns in data load. It means if you want to load Clients table, then prepare view/table on database side with needed fields. (Or while connecting to DB write SQL script where choose required columns).
    2. Reduce the number of rows in a way I told step before (smaller period or any other filters, if possible).
    3. Sometimes better if you will do maximum SQL JOINes on database side then on Power BI side.

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

We have PBI Pro pack (not premium) and 10Go.

I see it seems we use only 825Mo. So, no dataset exceeds 1Go, right?

 

 

Where is the "memory pb"? I don't understand

zoloturu's avatar
zoloturu
Memorable Member
8 years ago

Anonymous,

 

Power BI Desktop mainly consists of two applications:

  • Power BI Desktop (UI and back-end)
  • MS SQL Server Analysis Services

 

Main calculations are done by the second one.

You can check memory RAM using Windows task manager and Resource Monitor by tracking msmdsrv.exe:

msmdsrv.exe

 

 

 

 

 

 

 

msmdsrv 2

If PBIX file size is 300MB. The same size it will have in Power BI Service (what we can see in your screenshot). But it is just compressed size. When you do refresh the report then it can take up to 20GB for instance. In that case, it is using RAM. When you have just Power BI Free/Pro without Embedded/Premium capacity then you use capacity shared with all other users.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Ok I tracked msmdsrv (max while refreshing = 11Go)

     

    and my memory (max while refreshing = 17,6Go)

     

    Here is the problem?

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      I don't really understand which memory is used when a scheduled refresh is working...

      What can I track?

      When a scheduled refresh is on, I don't see anything increasing. The memory RAM is still 4Go and no msmdsrv active...

      • zoloturu's avatar
        zoloturu
        Memorable Member
        8 years ago

        So Anonymous,

         

        The issue here that your report is using11 GB while refreshing. That means you need to buy additional memory (capacity, as I mentioned earlier) and your report will not refresh without it because of a huge amount of data. 

         

        If you not willing to do so, you need to optimize your Power BI report data model. Can you share a screenshot of it?