Issue Refreshing model by SSIS Catalog - Migrating Azure Analyses Service to Power BI Premium Gen 2

[rafaelfeo83]

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

[Anonymous]

Hi @rafaelfeo83 ,

Can't reproduce the scenario.

This is the only similar post that I found according to the error message.

https://stackoverflow.com/questions/63368293/analysis-services-execute-ddl-task-connect-string-for-p... 

Best Regards,

Jay

[rafaelfeo83]

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