How can we improve Microsoft Azure Analysis Services?

Automated processing of SSAS tabular model through Portal

156 votes
Sign in
(thinking…)
Sign in with: oidc
Signed in as (Sign out)

We’ll send you updates on this idea

Mehmet Bakkaloglu shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

11 comments

Sign in
(thinking…)
Sign in with: oidc
Signed in as (Sign out)
Submitting...
  • Tom commented  ·   ·  Flag as inappropriate

    Running automation accounts and runbooks to do this... Please give us the option to schedule the processing of tabular models via the portal already!! Seems like a no-brainer and something that should take your devs a few hours to implement, especially considering there's an API available

  • Roberto commented  ·   ·  Flag as inappropriate

    Having a task in ADF to orchestrate automated processing would also be nice to have.

  • John Klacynski commented  ·   ·  Flag as inappropriate

    Today in order to refresh aas from DW, we built a custom program/utility. its one of the most complex portions of the pattern, and its disconnected from the pipeline (ADF) orchestration patterns.
    Future - Need better data refresh integration between DW and AAS via a policy and or thru data factory pipeline activity. this will simplify our pattern, reduce support costs, and provide better overall data orchestration refresh status/health.

  • Conrad commented  ·   ·  Flag as inappropriate

    Learning to create an Azure function in Automation is useful knowledge that could be applied elsewhere. But,...scheduled refresh through the UI is a fundamental need for an Azure AS cube. It's not a v 2.0 feature.

  • Tyler Becker commented  ·   ·  Flag as inappropriate

    Azure function is a work around, but it would be great to have this functionality built into to a scheduling agent right in Azure AS.

  • Hikmer commented  ·   ·  Flag as inappropriate

    There should be an easy way to implement this in Azure Portal or an option to run a local SQL agent.

  • Mehmet Bakkaloglu commented  ·   ·  Flag as inappropriate

    In the meantime what is the alternative? Do we need to write .NET code and automate this through Azure Batch / Azure Data Factory?

Feedback and Knowledge Base