@igorabdo Odd that you should say that. I have a report that refreshes and then blanks out the numbers. I can refresh the model and publish the report and have the data show but only until I leave the page or refresh the page in the service. Then it blanks out again.
I have deleted the data and am republishing it now. You may be onto something with the gateway because we just updated and moved the gateway to another server. Since then we have had nothing but issues.
@kcantor I do not know what else to do. I publish, and then comes the portal and ruins everything.My users have no confidence. The reports have to be updated manually because the gateway causes problems.
Since the last week we're facing troubles with reports refresh process, both auto and manually.
1) Some data is missed. After some operations like Append ot Change type 5-million rows database cuts to 1000 rows.
2) At one time some tables show 1000 rows, at another time - another tables.
3) Now the report is refreshing and finish with the error: positive number is required. Parametr name is value. What does it mean?
Please advise me what I should do. I'm a bit worried as it took hours to refresh 1 report and when it refreshs successfully it seems to me like a miracle.
I worked with IT. We deleted the gateway and installed a new version. I upgraded both the desktop as well. I am now capturing all rows as it should be.
Fingers Crossed, I think I may be out of the woods. I will know in the morning.
As for today, I have manual refreshes that have completed with all rows.