Matrix and Table visual loses data on refresh

[kcantor]

I have two smaller, uniquie data models that has worked for several months with no issues. They are in my personal workspace, not in an app and not in a group. They refresh as scheduled but when they refresh, they lose data instead of gaining it. For example, one shows all weeks of the year through current with the number of orders imported. When the model refreshes at 7:30 am, all weeks except for 2 drop off the report. It is not filtered and the database has no issues. It is a direct import table. If I open the data model on the desktop and refresh the data, it works perfectly and keeps all of the weeks. I can then republish and it will work again for several hours before going blank again.

I have removed the data model, reports, and dashboards and republished from scratch only to have the same thing happen the next day. As stated, this is occuring with two different models built on two different data sources.

We have had issues with data loading (like many of you) and have recently transferred the gateway to a different server but the 100+ other reports and the 50+ datamodels work perfectly.

Any ideas?

[prihana]

Try using the import mode once and share the result

[kcantor]

@prihana

I did the import method yesterday and today, the report lost data again.

I am at a loss on this one as it only seems to affect two data models that have no unique connections. My other models have the same data connections and do not suffer from this issue.

Both reports and models lost 90% of their data this morning as well.