Forum Discussion
Issue Refreshing model by SSIS Catalog - Migrating Azure Analyses Service to Power BI Premium Gen 2
Hello Guys,
We have migrated some models from Azure Analyses Service to Power BI Premium Gen 2 Workspaces by tabular editior.
Now we have refreshed the model from Gen 2 by SSMS is it ok!!! From Visual Studio by Analyses Services DDL Task is it ok!! But when we tried execute the package from DTS or SSIS Catalalogs the task ending with error status.
We confirmed that string is the same when executing by SSMS or VS !!!
Any ideias?
Thanks
2 Replies
Hi rafaelfeo83 ,
Can't reproduce the scenario.
This is the only similar post that I found according to the error message.
Best Regards,
Jay
Hi Jay, Thanks for your reply
We have already configured serviceprincipal with appid@tenantid like the link. Its work well.Our situation is exactly this:
1. When run by SSMS -> Integration Services->Execute Package the package is successfully completed. See below:
2- When we configure by SSMS - SQL Agent Job->or
We got this message:
Any ideas.
Thanks
