Operation cancelled because of locking conflicts

[Mjdrejza1722]

I have seen a lot of posts on this particular topic of locking conflicts.  I understand the basic premise of the problem.  I have had a problem with one of my visuals freezing/locking up (posted separately).  It's a wide table about 50 columns.  Seventeen (17) of the columns are just data columns I am displaying; the rest of the columns are measures (mostly simple measures involving simple aggregation and filtering).  The data and measures are assembled from a handful of data tables.  After getting about 99% to where I wanted this table, I started having trouble re-adding columns (that were previously in the table), renaming columns, etc.  I tried to rebuilt it and it seemed to work fine, but then I just tried to change one data column's option to "display items with no data," and this caused the visual to stop loading and presented me with the error "Operation cancelled because of locking conflicts."  Assuming it is similar or the same concept as when I have gotten "not enough memory" errors, I understand that something is requiring too much processing.   What I am confused by is why certain things trigger it and others don't.  It seems like my visual shouldn't be so sensitive that I cannot rename a column/measure, or toggle a feature.   Is this problem just an issue of "the straw that broke the camel's back?"

[AmiraBedh · Accepted solution]

Locking conflicts in Power BI arise when there are simultaneous read/write operations on the same data, aimed at ensuring data integrity. Even seemingly straightforward actions like renaming a column or toggling a feature might trigger these conflicts, as Power BI performs a series of resource-intensive operations behind the scenes. When Power BI operates near its capacity, even slight additional loads might cause conflicts. To resolve this, consider simplifying your data model by removing unnecessary columns or measures, optimizing relationships and data types, using summarized tables for visuals where possible, splitting complex visuals into simpler ones, and ensuring your system has adequate resources for handling Power BI's demands.

[elia22gr]

@AmiraBedh I tried resolving this problem with Summarized table but then the visual didn't filtered by slicers. I tried to create relationships between the new summarized table and Dimension Tables but I couldn't. What am I missing?

[Mjdrejza1722]

I tried rebuilding some things and trusting more how the relationships played out.  I seem to have produced a more successful data model for now.