title: Analysis Services Execute DDL Task connect string for Power BI XMLA endpoint
body: <p>We have power bi premium and an XMLA endpoint enabled.</p>
  <p>I am trying to refresh partition in the dataset using a TMSL script.</p>
  <p>The microsoft doco says this should work with &quot;Analysis Services Execute DDL Task in SSIS.&quot;
  <a href="https://docs.microsoft.com/en-us/analysis-services/tmsl/tabular-model-scripting-language-tmsl-reference?view=azure-analysis-services-current" rel="nofollow noreferrer">https://docs.microsoft.com/en-us/analysis-services/tmsl/tabular-model-scripting-language-tmsl-reference?view=azure-analysis-services-current</a></p>
  <p>I can connect in SSIS (see below) but when i run the DDL Task with this conection I get a connection string is not valid messaage.</p>
  <p>any help appreciated.</p>
  <p>thanks</p>
  <p>Error: 0x0 at Analysis Services Execute DDL Task, Analysis Services Execute DDL Task: The connection string is not valid.
  Error: 0x0 at Analysis Services Execute DDL Task, Analysis Services Execute DDL Task: Execution of DDL failed.
  Task failed: Analysis Services Execute DDL Tas</p>
  <p><a href="https://i.stack.imgur.com/VF6Dn.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/VF6Dn.png" alt="Connection Manaager image" /></a></p>