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.

Stipulations

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

Resolution

1. Login to https://app.material.microsoft.com/residence?expertise=data-factory and Choose Dataflow Gen 2.

1. And rename the Dataflow.

1. Seek for Azure Evaluation Companies elements and Choose it

1. Present the Server and the Database particulars and beneath Superior Choices : enter the DAX question ( the output which that you must copy from AAS).

1. Then create a connection to the AAS through the Group account and check in and Click on ‘Subsequent’

1. 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.

Ultimate Supply transformations state.

The Superior editor code.

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

Now Choose the Sink / Vacation spot settings.

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

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

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

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

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


Know more about our company at Skrots. Know more about our services at Skrots Services, Also checkout all other blogs at Blog at Skrots

Thanks, Harsh
Founder | CEO — Skrots

Learn more about our blog at Blog at Skrots. Checkout our list of services on Skrots. Give a look at our website design at Skrots . Checkout our LinkedIn Page at LinkedIn.com. Check out our original post at https://blog.skrots.com/copy-data-from-azure-analysis-service-aas-through-microsoft-fabric/?feed_id=1441&_unique_id=65429d7a22807