Copy Data from Azure Analysis Service (AAS) through Microsoft Fabric

Problem Statement

It is possible to copy data from Azure Analysis services from Azure Data Factory (ADF) as stated in the blog : Copy Data from SSAS/AAS through Azure Data Factory .

But this requires us to create a Linked Server via a SQL server and unfortunately in case if MFA is enabled on an Account which is being leveraged for creation of Linked Server to AAS ; one cannot create a linked server for automated jobs (and would only be able to create on an interactive basis)

Is it possible to Copy / Extract data from Azure Analysis service with MFA enabled on AD accounts in an automated way.

Prerequisites

MSFT Fabric Dataflow Gen 2
AAS Tabular Model

Solution

Login to https://app.fabric.microsoft.com/home?experience=data-factory and Select Dataflow Gen 2.

And rename the Dataflow.
Search for Azure Analysis Services components and Select it
Provide the Server and the Database details and under Advanced Options : input the DAX query ( the output which you need to copy from AAS).

Then create a connection to the AAS via the Organization account and sign in and Click 'Next'
Do the necessary transformation that you need in the Power Query mode.
In this scenario, we would add a new column called AuditDate for auditing purpose.

Final Source transformations state.

Final source

The Advanced editor code.

Editor

let
    Source = AnalysisServices.Database("<<ServerName>>", "<<DatabaseName>>", [Query = "EVALUATE SUMMARIZECOLUMNS('Dates'[Fiscal Year], ""Sold USD"", [Sold USD])"]),
    #"Added custom" = Table.TransformColumnTypes(
        Table.AddColumn(Source, "AuditDate", each DateTime.LocalNow()), 
        {{"AuditDate", type datetime}}
    )
in
    #"Added custom"

Now Select the Sink / Destination settings.

Data destination