- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Capacity Exceeding Limit
Hello PowerBI Community,
Me and my team are currently facing an issue with exceeding capacity at the moment we have 2 capacities currently and both are exceeding the limit. We have gone about a process of optimizing the DAX measures in the dataset which were previously using a significant amount of resource however do bare in mind that our calendar is a company financial year calendar so we are unable to use time intelligence in DAX measures to make it the most optimal. The number of users has gone up signifcantly within the last year however the capacity we have is recommended for the size of our organization so scaling up capacity really should be a last option. Can anyone recommend best practices to go through things that we should avoid including in our reports and datasets so they are the most efficient they can be, as most of the CU is taken up querying so either there are still some DAX inefficiences or some Front end mistakes that should be avoided i.e. too many card visuals or other stuff that we have not considered.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I think there is a lot to do here
1- use vertipaq analyzer to analyze your model columns and tables cardinality and size also check data types.
2- provision log analytics workspace to log AS logs and use the prebuilt templates to check which query and which visual is causing problems and use a lot of resources
3-schedule data refresh outside workhours.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @Manesh_13
Did bradsy 's method solve your problem? If yes, could you please mark it as a solution? This will be of great help to other users experiencing similar problems. Thank you!
If you still have questions, please feel free to contact me.
Best Regards,
Yulia Xu
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You have probably already seen this, but if not, it is a good guide for things to look for: https://learn.microsoft.com/en-us/power-bi/guidance/power-bi-optimization
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
11-07-2024 04:38 AM | |||
08-29-2024 05:38 AM | |||
11-19-2023 04:06 PM | |||
10-10-2024 05:29 AM | |||
08-25-2021 02:24 PM |
User | Count |
---|---|
26 | |
24 | |
13 | |
10 | |
9 |
User | Count |
---|---|
50 | |
41 | |
24 | |
19 | |
16 |