Forum Discussion

acevernon's avatar
acevernon
New Member
8 years ago
Solved

Dataset refresh error on just one report

Hi   I have 4 different reports in my powerBI app and I am using the same gateway for all. 3 out 4 reports are refreshing just fine either manual or scheduled. However, there is one report that kee...
  • acevernon's avatar
    acevernon
    8 years ago

    Hi All

     

    I found the solution to my issue. The database servers where the data set for the specific report that was failing had a duplicate row on one of the tables it was grabbing data from. I removed the duplicate and it started flowing through properly again. 

     

    I tried running my report on power BI desktop and when I tried refreshing there, it showed me a message that the refresh was failing because it was waiting for a field to refresh. WHen i checked the field, there was an error message which says there are 2 entries of that specific data. so I removed one of them. 

     

    Long story short, after pretty much the whole day looking for the cause of the issue, powerBI Desktop was great enough to be displaying specific error messages that would help users like me identify the cause of the problem. While the web app is nice, it has its limitations like showing weird error messages that does not make sense to me. 

     

    Hope this helps others having the same problem.

     

    Thanks

deepu299's avatar
deepu299
Advocate V
8 years ago

acevernon I had same issue today and as I refresh the page the error occurs on the reports randomly. With a refresh reports 1,3,4 might work and report 2 fails, rpt 1 works and other 3 can fail.. like that. there is no particular sequence. See if it happens for you too. The solution for me was to uninstall the gateway and reinstall Feb 2018 version. If yours is the same issue, hopefully this helps. 

  • acevernon's avatar
    acevernon
    New Member
    8 years ago

    Thanks Deepu

     

    I've tried that couple of times already today. But issue still the same - the 4th report is always the one failing when refreshing. 1,2,3 are always fine.  Are you referring to the personal gateway or the normal one? I've tried both now.