Forum Discussion
Power BI RAM Issues
If your model size is 500MB (is not same as file size, because file is double compressed), you need 500MB of RAM for model, + additional 500MB during processing, + additional RAM for source data (it can be much larger, because it is uncompressed raw data, but it's limited up two 8milions segments which processed parallely). Is not count easy, best way is check memory allocation during idle, and memory allocation during processing peak.
Also depends on number of reports, if you have 500MB model you need 500MB constantly, +e.g. 2GB during processing. But if you have 10 reports by 500MB, you need 5GB constantly, + and probably 2GB for processing (because you will not process everything at same time)
If your model size is 500MB (is not same as file size, because file is double compressed), you need 500MB of RAM for model, + additional 500MB during processing, + additional RAM for source data (it can be much larger, because it is uncompressed raw data, but it's limited up two 8milions segments which processed parallely). Is not count easy, best way is check memory allocation during idle, and memory allocation during processing peak.
Also depends on number of reports, if you have 500MB model you need 500MB constantly, +e.g. 2GB during processing. But if you have 10 reports by 500MB, you need 5GB constantly, + and probably 2GB for processing (because you will not process everything at same time)
Thanks josef78 very much,
So which means to do Import Method via Reporting Server, this is the process of consumption for RAM.
And it all depends upons Import Reports size from Reporting Server and based on RAM(64 GB) in Server(and also depends upon Power Query steps, SQL Query writing as well) which means it should not be enough because currently already 80% consumption happening in Development area..May be its not great way to this process import method if we don't extend RAM.
Thanks for making me understanding this.
And what if we access Power BI Import process via Service, is it same consumption of RAM in Production Server? may be not for Power Query steps because it will take our local memory isn't it? and for SQL query in Import Method will it take from Server Memory?
We just worried of Data Governance to make sure data is not going outside like end users should not export before we move to service and also our reporting service sits in Citrix currently so we want to take steps carefully before we move to service.
Any inputs highly appreciated.