Forum Discussion

aodendaal's avatar
aodendaal
New Member
8 years ago
Solved

There was an error when processing the data in the dataset.

I've recently setup PowerBI on the web to connect to an Azure SQL database. I setup refresh scheduling but I get the message There was an error when processing the data in the dataset. and the detail...
  • v-qiuyu-msft's avatar
    8 years ago

    Hi aodendaal,

     

    From the error message, the issue seems related to the Provinces table. Please download the report from Power BI service and open it in Power BI desktop, click Refresh in desktop to see which detail error message display. 

     

    Best Regards,
    Qiuyun Yu 

  • aodendaal's avatar
    8 years ago

    Thank you, I downloaded the report and refresh the data and I got a better error description. I had duplicate data in a field being used by an inactive relationship. I deleted the relationship, re-uploaded the report and the dataset could refresh correctly.

     

    It's a little annoying that the error isn't displayed on the web and you have to download the report to see what is really going on.

     

    In any case, thank you for the assist.