May 23, 2019 at 5:04 am
Hello,
I have a problem. We have a SSAS Tabular model which is scheduled to be refreshed daily (with a refresh full on the model). The problem is that one (or sometimes two) tables are empty after such a scheduled refresh.
When I refresh those tables manually everything is fine again and I am very sure that during the scheduled full refresh of the model there is data in source as the source are database views on our DWH (SQL Server relational database).
We are using SQL Server 2017 CU 12. Both DWH and SSAS are on the same VM.
Had anyone similar issues or an idea what could be the root cause?
Thanks and best regards,
Martin
May 24, 2019 at 8:18 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
April 15, 2021 at 4:34 am
Was there any known resolution to this issue? I experience same where 1 specific table, every now and then, does not refresh correctly. I have an hourly job which executes the below FULL refresh of the table, however every now and then, the table is empty. If I leave ot to self-refresh on the next hour, everything comes right. Very curious, and unknown how to troubleshoot.
{
"refresh": {
"type": "full",
"objects": [
{"database": "SalesOperations", "table": "Distribution Orders"}
]
}
}
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply