Copy Knowledge from Azure Evaluation Service (AAS) by Microsoft Material

Downside Assertion

It’s potential to repeat knowledge from Azure Evaluation companies from Azure Knowledge Manufacturing facility (ADF) as said within the weblog : Copy Knowledge from SSAS/AAS by Azure Knowledge Manufacturing facility .

However this requires us to create a Linked Server through a SQL server and sadly in case if MFA is enabled on an Account which is being leveraged for creation of Linked Server to AAS ; one can not create a linked server for automated jobs (and would solely have the ability to create on an interactive foundation)

Is it potential to Copy / Extract knowledge from Azure Evaluation service with MFA enabled on AD accounts in an automatic approach.


  1. MSFT Material Dataflow Gen 2
  2. AAS Tabular Mannequin


  1. Login to and Choose Dataflow Gen 2.

    And rename the Dataflow.
  2. Seek for Azure Evaluation Companies elements and Choose it
    Data source
  3. Present the Server and the Database particulars and beneath Superior Choices : enter the DAX question ( the output which that you must copy from AAS).
    Connect data source
    Then create a connection to the AAS through the Group account and check in and Click on ‘Subsequent’
    Connection credenctials
  4. Do the required transformation that you just want within the Energy Question mode.
    On this state of affairs, we might add a brand new column referred to as AuditDate for auditing goal.
    Custom column

Ultimate Supply transformations state.

Final source

The Superior editor code.


    Supply = AnalysisServices.Database("<<ServerName>>", "<<DatabaseName>>", [Query = "EVALUATE SUMMARIZECOLUMNS('Dates'[Fiscal Year], ""Offered USD"", [Sold USD])"]),
    #"Added customized" = Desk.TransformColumnTypes(
        Desk.AddColumn(Supply, "AuditDate", every DateTime.LocalNow()), 
        {{"AuditDate", kind datetime}}
    #"Added customized"

Now Choose the Sink / Vacation spot settings.

Data destination

As of as we speak solely 4 Sinks are supported.

So for our use case, we might Choose Azure SQL Database.

Much like #3, create a connection to Azure SQL Database

Data destination

You’ll be able to both create a brand new desk on run or map it to an present one.


In our use case, we might create a brand new desk in vacation spot with the title AASTransform.

One can both append the info or change the info based mostly on the settings.


We’d proceed with Append knowledge state of affairs.

And Click on on “Save settings”.

Lastly Click on on “Publish”


The Dataflow begins the first execution as soon as it is revealed.

Database output

Database output

To Execute once more, Click on on the Refresh now part of the dataflow.


As now we have enabled Append knowledge at sink, we might have 2 distinct AuditDates

Audit date

12. As a way to schedule the info extraction, one can both schedule the dataflow refresh frequency through Dataflow Settings:

Copy AAS

OR schedule through Material Knowledge pipelines.

Know extra about our firm at Skrots. Know extra about our companies at Skrots Companies, Additionally checkout all different blogs at Weblog at Skrots

Show More

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top button