Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Solved! Go to Solution.
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
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
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.