Evenementer
Power BI DataViz World Championships
Feb 14, 4 PM - Mar 31, 4 PM
Mat 4 Chance fir matzemaache kënnt Dir e Konferenz-Pak gewannen an op d’LIVE Grand Finale zu Las Vegas kommen
Méi gewuer ginnDëse Browser gëtt net méi ënnerstëtzt.
Upgrat op Microsoft Edge fir vun de Virdeeler vun leschten Eegeschaften, Sécherheetsupdaten, an techneschem Support ze profitéieren.
APPLIES TO:
Power BI Desktop
Power BI service
When you load a report page or make changes to the fields in a visual, that visual sends a query to your report's data source. Processing these queries requires both time and computer memory. To prevent any single query from consuming too many resources, queries in published reports are subject to limits on the time a query can run (timeouts) and the amount of memory that query can use (memory limits). These limits may change based on where your data is hosted.
The following table shows the timeouts and memory limits applied by different capacities.
Capacity | Timeout | Memory limit |
---|---|---|
Shared | 225 seconds | 1,048,576 KB (1 GB) |
Premium | 225 seconds | 10,485,760 KB (10 GB) |
SQL Server Analysis Services | 600 seconds | 1,048,576 KB (1 GB) |
Azure Analysis Services | 600 seconds | 10,485,760 KB (10 GB) |
If a visual sends a query that reaches one of the limits applied by the hosting capacity, that visual then displays an error.
Power BI Desktop does not naturally apply any of these limits to local models. However, you can use query limit simulations to test any limits that may be applied to your report after you publish it.
By default, new reports have "auto (recommended)" selected. With auto limits, Power BI will do its best to identify where the model is hosted and apply those limits. Otherwise, it will default to the Shared capacity limits to ensure that queries which complete on Desktop will complete for published reports, regardless of where the report's data ends up hosted. Below the dropdown, you can see the exact timeout and memory limits currently being applied for the chosen capacity.
If you choose to apply custom limits, enter specific timeout and memory limits in the input field. When you set your own limits, you can use "0" to indicate "no limits."
Evenementer
Power BI DataViz World Championships
Feb 14, 4 PM - Mar 31, 4 PM
Mat 4 Chance fir matzemaache kënnt Dir e Konferenz-Pak gewannen an op d’LIVE Grand Finale zu Las Vegas kommen
Méi gewuer ginnTraining
Modul
Optimize a model for performance in Power BI - Training
Performance optimization, also known as performance tuning, involves making changes to the current state of the semantic model so that it runs more efficiently. Essentially, when your semantic model is optimized, it performs better.
Zertifizéierung
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.
Dokumentatioun
Troubleshooting tile errors - Power BI
See explanations and solutions for common errors you might encounter with tile refresh in the Power BI service.
Let users personalize visuals in a report - Power BI
Learn how to let report readers create their own view of a report without editing it, all in report reading view.
Change settings for Power BI reports - Power BI
Learn how to change settings for reports and control how report readers interact with your reports in Power BI Desktop and the Power BI service.