Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Dataset error in Power BI service

Hello everyone! I have this kind of error in Power BI Serivice: The report is created internally in Power BI Serivice, not in Power BI Desktop. The data is not refreshing. Also, I got one m...
Need Help
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    Hi , Anonymous 

    Based on my query in the internal database for this error details you provided, I got an error message like this:

     

    An error occurred running the query.Details: ErrorCode=OnPremiseServiceException, ProviderErrorCode=0xC1450012, ErrorSource=User, Message=Failed to move the data reader to the next row.

    Message=Failure encountered while getting the next row in the result-set

     

    According to my experience or understanding, generally the field in the visual above the report in the presentation of the calculated value has a field type/DAX expression operation type or RLS/OLS limit and other errors will lead to this error message, if it is convenient, you can click this report on the service to enter the "Edit" mode and delete each field on this problematic visual to check whether the problem will disappear. This will help you find the field/measure that is having the problem and facilitate further troubleshooting.

     

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

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

v-yueyunzh-msft's avatar
v-yueyunzh-msft
Community Support
3 years ago

Hi , Anonymous 

Based on my query in the internal database for this error details you provided, I got an error message like this:

 

An error occurred running the query.Details: ErrorCode=OnPremiseServiceException, ProviderErrorCode=0xC1450012, ErrorSource=User, Message=Failed to move the data reader to the next row.

Message=Failure encountered while getting the next row in the result-set

 

According to my experience or understanding, generally the field in the visual above the report in the presentation of the calculated value has a field type/DAX expression operation type or RLS/OLS limit and other errors will lead to this error message, if it is convenient, you can click this report on the service to enter the "Edit" mode and delete each field on this problematic visual to check whether the problem will disappear. This will help you find the field/measure that is having the problem and facilitate further troubleshooting.

 

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

Best Regards,

Aniya Zhang

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