Power BI Pagintaed Report Error - The operation was cancelled because of locking conflicts.

[RajendraNimmala]

Hello Everyone,
I created  a simple paginated report which uses fields from three tables. The SQL Query in the back end runs fine and the Power BI Interactive report also works fine.
But there is only one issue with the Paginated report. I am getting below error while running the paginated report. The data size is less. I even get the error while filtering the output for one record.

The operation was cancelled because of locking conflicts.
----------------------------
Cannot read the next data row for the dataset 'XYZ'.
----------------------------
An error has occurred during report processing.
----------------------------
An error occurred during local report processing.

I would appreciate it if someone could assist to fix the issue.

Thanks

Raj

[v-easonf-msft · Accepted solution]

Hi, @RajendraNimmala 

This kind of problem is usually caused by long-running  queries.

You may need to minimize the MDX query duration and avoid processing at peak hours to avoid query and processing collisions.

Please check the following links.

Analysis Services Stops Accepting New Connections –Processing commit locks hurt 

SSRS :The operation was cancelled because of locking conflicts. 

Best Regards,
Community Support Team _ Eason