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)
Hi Sudhakar510 ，
In Power Bi desktop, if you import data into desktop, data is stored locally within powerbi in pbix (powerbi file) file. For Power BI service, the data from the file is stored on Azure. The Power BI service is built on Azure, which is Microsoft’s cloud computing infrastructure and platform. More details, please review this blog.
Both on-prem and on Microsoft Azure SQL database, it depands the type of you connect data. If you upload using import model in desktop, it still store the data in the .pbix file.
In Power BI service, if you are referencing SQL Azure DB, then you don't need a gateway. If it is on-premises, then you do. In both these cases, if you change the connection type to "import" model- then the data will be stored in the Power BI Azure backend. If you get data using a live connection, no data is stored in the cloud, just some caching.
refer:
https://community.powerbi.com/t5/Service/Where-is-data-stored-on-importing-to-power-bi/m-p/288537
Best Regards
Lucien