Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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
User | Count |
---|---|
98 | |
91 | |
84 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |