Forum Discussion

jkeizer's avatar
jkeizer
Frequent Visitor
2 years ago

Embedded visual errors - Failed to move the data reader to the next row

Hi,

 

Starting today all visuals in our embedded report crash. No issues before today and the report still works fine when viewing it in desktop or the Embedded service workspace. No significant changes were made to the report.

When clicking on "see details" in the crashed visual I get:

"Couldn't load the data for this visual" (without any helpful details).

 

When looking at the network logs for the embedded application I see "query" requests for the individual visuals and they all contain this error:

"dsr": {"DataShapes": [{"Id": "DS0","odata.error": {
"code": "QueryUserError","source": "User",
"message": {"lang": "en-US",
"value": "Failed to move the data reader to the next row."},
"azure:values": [{"timestamp": "2024-01-16T17:32:07.6064578Z"}]}}]},

 

The error is trown in the "Execute DAX Query" event so I looked again at all queries but there are no errors visible in Desktop.

 

Could this be a generic Power BI issue? If not what could be causing this.

 

Best,

Joery

Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi jkeizer ,

    Is this still a problem? Is the error not reported in Power BI Desktop? Have tried clearing the browser cache? Has someone made some changes to the report?

    Please pay attention. DirectQuery will be slower when dealing with large volumes of data. Thus, this error is possible due to the high data volume.

     

    How to Get Your Question Answered Quickly 

     

    If it does not help, please provide more details.

     

    Best Regards
    Community Support Team _ Rongtie

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • jkeizer's avatar
      jkeizer
      Frequent Visitor
      2 years ago

      Hi Anonymous ,

       

      Yes it's still a problem. No errors in desktop or service when I view it in the workspace. Only in the embedded app, it was working without issues for months before yesterday. I have tried clearing the browser cache and I don't think it's related to data volumes because even simple slicers do not load anymore. There is RLS on the report but no changes related to that were made, and when testing RLS in desktop it still works.

       

      Update:

      We've had a very similar issue last year, back then it turned out to be a Microsoft issue. Another user reported this at the time:

      Embedded reports built over multiple XMLA datasets... - Microsoft Fabric Community

       

      I also checked the Embedded Playground (because last year the reports were fine there) and they load without any issues.

       

      Best,

      Joery

      • arjunislearning's avatar
        arjunislearning
        Frequent Visitor
        2 years ago

        Hey Joery!

        Could you please share the findings and solution of this issue, we are facing this weird issue occasionaly.

        Most of the time, report is working fine but once in a while (mostly once in a fortnight we encounter this).

        More info: we are using common dataset for many reports with live connection to Dataset.

        Dataset refresh once a day (import mode), issue seen after scheduled refresh (whenever seen).

        Issue seen with RLS roles only, not when RLS role not involved (Never seen in Desktop).

        Gets resolved automatically after few hours.