Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only

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

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

    Posted Oct 28, 2022 05:24 PM
    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.

    ------------------------------
    Raj N
    30005
    ------------------------------