Forum Discussion
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 keeps failing the refresh. The visual also does not show accurate information anymore. When I try manually refreshing, I keep getting this error:
Please try again later or contact support. If you contact support, please provide these details.
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
3 Replies
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.
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.
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
