Forum Discussion
杰克逊1300
Oct 16, 2023Copper Contributor
Calling stored procedures to refresh the SSAS tabular model often results in errors
I have published 4-5 table models on the SSAS instance, and I refresh the data of the table model every day after the data warehouse is refreshed. However, they often report errors and the logs canno...
olafhelper
Oct 16, 2023Bronze Contributor
The OLE DB provider 'MSOLAP' for linked server 'SSAS-001' returned the message
杰克逊1300 I wonder about "linked server" in the error message.
Don't you access the MySQL directly, but the loop way of a MS SQL Server linked server?
- 杰克逊1300Oct 16, 2023Copper ContributorHI, olaf,
thank you for your reply.
I tested that the script for the stored procedure can access the linked server. Yesterday, it was successfully accessed and refreshed. I am not sure what caused the error, possibly due to the network? Insufficient resources?