locked
How to process "process all" Azure Analysis Services on a scheduled basis RRS feed

  • Question

  • I have been investigating Azure Automation for this propose, but really struggling to find a step by step guide as to how to process "process all" Azure Analysis Services on a scheduled basis. Can anyone assist.

    'If this was helpful, please mark and an answer or as being helpful'

    Monday, May 15, 2017 9:13 AM

All replies

  • I find it astounding that there is almost zero material out there on how to process the AAS models via a schedule!! One of the most fundamental parts of SSAS is the ability to process the data on a scheduled basis, such as through ETL, yet as to how to achieve the same with AAS using azure services....nadda. Without it, MS cannot expect a huge uptake! Come on MS, advise as to how this is possible as I have now had both PowerShall and C# coders trying to get it working!

    'If this was helpful, please mark and an answer or as being helpful'

    Tuesday, May 16, 2017 7:10 AM
    • Azure Functions
    • Azure Automation
    • SQL Agent jobs (from SQL instance running On-Prem or in AzureVM) w/ XMLA, TOM, TMSL commands (tons of links for this approach)

    Data Enthusiast | @SQLbyoBI | www.opifexsolutions.com

    Tuesday, May 16, 2017 6:28 PM