New Power BI capacity settings give more control to admins

Vlad Turiceanu
by Vlad Turiceanu
Editor-in-Chief
Passionate about technology, Windows, and everything that has a power button, he spent most of his time developing new skills and learning more about the tech world. Coming from a solid background in PC... Read more
Affiliate Disclosure
5 new Power BI capacity settings give more control to admins
To fix various PC problems, we recommend Restoro PC Repair Tool:
This software will repair common computer errors, protect you from file loss, malware, hardware failure and optimize your PC for maximum performance. Fix PC issues and remove viruses now in 3 easy steps:

  1. Download Restoro PC Repair Tool that comes with Patented Technologies (patent available here).
  2. Click Start Scan to find Windows issues that could be causing PC problems.
  3. Click Repair All to fix issues affecting your computer's security and performance
  • Restoro has been downloaded by 0 readers this month.

After recently revealing the July round-up of updates for Power BI, Microsoft now has introduced five new Power BI Premium Capacity settings.

Power BI admins now have more control over capacities

These new settings are mainly aimed at administrators, to better control the capacities and to avoid any potential issues on the way.

Also, the Power BI admins can now set limits to Max Offline Dataset Size, create a more performant capacity, and prevent reports from affecting others using the capacity.

Run a System Scan to discover potential errors

Restoro Scan

Click Start Scan to find Windows issues.

Restoro Fix

Click Repair All to fix issues with Patented Technologies.

Run a PC Scan with Restoro Repair Tool to find errors causing security problems and slowdowns. After the scan is complete, the repair process will replace damaged files with fresh Windows files and components.

Here’s the detailed description of each of the five new capacity settings and how they work in a real-world scenario:

Setting Name Description Scenario
Max Offline Dataset Size (GB) Maximum size of the offline dataset in memory. This is the compressed size on disk. Default value is set by SKU and the allowable range is from 0.1 – 10 GB When users are experiencing slowness due to a large dataset taking up memory resources , admins would very often end up in the similar cycle of first identifying the culprit datasets, contacting the owner or migrating to a different capacity. With this new setting, admins can now configure the dataset size and prevent report creators from publishing a large dataset that could potentially take down the capacity and secondly save the admin from the painful cycle of identifying and mitigating.
Query Memory Limit (%) Applies only to DAX measures and queries. Specified in % and limits how much memory can be used by temporary results during a query. Some queries/calculations can result in intermediate results that use a lot of memory on the capacity. This can cause other queries to execute very slowly, cause eviction of other datasets from the capacity, and lead to out of memory errors for other users of the capacity. Without this setting, capacity administrators would find it challenging to identify which report/query is causing the problem, so that they could work with the report author to improve the performance. With this new setting, admins can better control impact of bad or expensive report on others using the capacity.
Query Timeout (seconds) An integer that defines the timeout, in seconds, for queries. The default is 3600 seconds (or 60 minutes). Note that Power BI reports will already override this default with a much smaller timeout for each of its queries to the capacity. Typically, it is approximately 3 minutes. When users are experiencing spinning on the report primarily due to another expensive report, admins would sometimes have to move the workspace to a different capacity. With the new settings, admins can better control expensive queries so that they have less impact on other users of the capacity.
Max Intermediate Row Set Count The max number of intermediate rows returned by DirectQuery. Default value is set to 1000000 and allowable range is between 100000 and 2147483647 When a query to a DirectQuery dataset results in a very large result from the source database, it can cause a spike in memory as well as a lot of expensive processing of data. This can lead to other users and reports running low on resources. This setting allows the capacity administrator to adjust how many rows can be fetched by an individual query to the data source in a dataset.
Max Result Row Set Count Defines the maximum number of rows returned in a DAX query. Default value is set to -1(no limit) and allowable range is between 100000 and 2147483647 Sometimes, a user can execute an expensive DAX query that returns a very large number of rows. This can cause a lot of resource usage and affect other users and reports executing on the capacity. This setting allows the capacity administrator to limit how many rows should be returned for any individual DAX query.

If you’re a Power BI admin, you can access these settings on the Admin Portal. There, you’ll have to go to the Capacity settings page and under the Management tab, expand the Workloads section.

If you want to learn more about Power BI Premium and its capacities, you can access Microsoft’s official link.

READ ALSO:

idee restoro Still having issues? Fix them with this tool:
  1. Download this PC Repair Tool rated Great on TrustPilot.com (download starts on this page).
  2. Click Start Scan to find Windows issues that could be causing PC problems.
  3. Click Repair All to fix issues with Patented Technologies (Exclusive Discount for our readers).

Restoro has been downloaded by 0 readers this month.