Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayFilestore properties
Applies to: 
SQL Server Analysis Services
Azure Analysis Services
Fabric/Power BI Premium
Analysis Services includes the following filestore properties. These are all advanced properties that you should not change, except under the guidance of Microsoft support.
Note
MaxOfflineDatasetSizeGB is the only OLAP property that exclusively applies to Power BI.
Applies to Power BI only. Maximum size of the offline dataset in memory. This is the compressed size on disk. The default value is 0, which is the highest limit defined by SKU. The allowable range is between 0 and the capacity size limit.
Does not apply to Power BI. An advanced property that you should not change, except under the guidance of Microsoft support.
Does not apply to Power BI. An advanced property that you should not change, except under the guidance of Microsoft support.
Does not apply to Power BI. An advanced property that you should not change, except under the guidance of Microsoft support.
Does not apply to Power BI. An advanced property that you should not change, except under the guidance of Microsoft support.
Does not apply to Power BI. A Boolean property that indicates whether database files and cached files are accessed in random file access mode. This property is off by default. By default, the server does not set the random file access flag when opening partition data files for read access.
On high-end systems, particularly those with large memory resources and multiple NUMA nodes, it can be advantageous to use random file access. In random access mode, Windows bypasses page-mapping operations that read data from disk into the system file cache, thereby lowering contention on the cache.
You will need to run comparison tests to determine whether query performance is improved as the result of changing this property. For best practices on running comparison tests, including clearing the cache and avoiding common mistakes, see the SQL Server 2008 R2 Analysis Services Operations Guide. For additional information on the tradeoffs of using this property, see https://support.microsoft.com/kb/2549369.
To view or modify this property in SQL Server Management Studio, enable the advanced properties list in the server properties page. You can also change the property in the msmdsrv.ini file. Restarting the server is recommended after setting this property; otherwise files that are already open will continue to be accessed in the previous mode.
Does not apply to Power BI. An advanced property that you should not change, except under the guidance of Microsoft support.
Does not apply to Power BI. An advanced property that you should not change, except under the guidance of Microsoft support.
Does not apply to Power BI. An advanced property that you should not change, except under the guidance of Microsoft support.
Does not apply to Power BI. An advanced property that you should not change, except under the guidance of Microsoft support.
Does not apply to Power BI. An advanced property that you should not change, except under the guidance of Microsoft support.
Does not apply to Power BI. An advanced property that you should not change, except under the guidance of Microsoft support.
Server properties in Analysis Services
Determine the Server Mode of an Analysis Services Instance
Additional resources
Training
Module
Understand scalability in Power BI - Training
Scalable data models enable enterprise-scale analytics in Power BI. Implement data modeling best practices, use large dataset storage format, and practice building a star schema to design analytics solutions that can scale.
Certification
Microsoft Certified: Power BI Data Analyst Associate - Certifications
Demonstrate methods and best practices that align with business and technical requirements for modeling, visualizing, and analyzing data with Microsoft Power BI.