Forum Discussion

Bamak's avatar
Bamak
Icon for Helper V rankHelper V
6 years ago
Solved

PBI Report Server architectural considerations , with mode IMPORT

Hi I would like hosted on Power BI report server some reports with  import mode for datasets My client asks me for my choice of server architecture I saw on the blogs production configuration of...
Report Server
  • Jon-Heide's avatar
    Jon-Heide
    6 years ago

    Import/Cached datasets are loaded completely into memory for perf reasons. So, you would be best to increase the RAM available on the report server machine. For the SQL database, suggest following SQL hardware guidelines or scale out. The underlying SQL database can become a bottlneck if there is a lot of concurrent traffic. Also the cached models are stored in SQL tables, so those need to be streamed from DB to server when loaded. 

Jon-Heide's avatar
Jon-Heide
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

Import/Cached datasets are loaded completely into memory for perf reasons. So, you would be best to increase the RAM available on the report server machine. For the SQL database, suggest following SQL hardware guidelines or scale out. The underlying SQL database can become a bottlneck if there is a lot of concurrent traffic. Also the cached models are stored in SQL tables, so those need to be streamed from DB to server when loaded. 

xavier76's avatar
xavier76
New Member
5 years ago

hello, in my organization we have to import report in power bi server but we don't know I can guarantee encryption of the data at rest. You say that imported data is loaded completely into memory. Isn't there a cache on the power bi server?

 

thanks,

Marco.