Forum Discussion

Medmbchr's avatar
Medmbchr
Icon for Helper IV rankHelper IV
3 years ago
Solved

Data refresh with memory problem

Hi,   I'm working on a PBI dashboard for one of my clients. I'm using my own laptop to do the development but once in a while I put the pbix file on my client's laptop to refresh data (via their SQ...
Need Help
Tutorial Requests
  • Migasuke's avatar
    Migasuke
    3 years ago

    Actually SQL should not really consume anything because it's running on server, not on your PC. Nevertheless I think Server Analysis Services runs everytime when load in Power Query is importing data.
    If the PC has 12 GB total memory, do not enable full 12 GB for PBI. Windows will not have enough memory to run and leads to easy crash. Maybe try something like 8 GB for PBI , 4 Containers and 2GB per container.

     

Medmbchr's avatar
Medmbchr
Icon for Helper IV rankHelper IV
3 years ago

Hi again,

 

I opened Task Manager while the file is refreshing data and it seems that the problem is not from Power BI, but from SQL Server Analysis Services! Which went up to consume up to 8 gb of RAM before Power BI gives me the update error.

Migasuke's avatar
Migasuke
Icon for Memorable Member rankMemorable Member
3 years ago

Actually SQL should not really consume anything because it's running on server, not on your PC. Nevertheless I think Server Analysis Services runs everytime when load in Power Query is importing data.
If the PC has 12 GB total memory, do not enable full 12 GB for PBI. Windows will not have enough memory to run and leads to easy crash. Maybe try something like 8 GB for PBI , 4 Containers and 2GB per container.