How to use tabular model Dax query in Azure Pipeline?

Question

I have a tabular model named ADM, which contains multiple tables. I need to retrieve data from it using a DAX query, structured as follows:

DAX

EVALUATE 
SUMMARIZECOLUMNS(
    'Fiscal Week Calendar'[Fiscal Year], 
    'Fiscal Week Calendar'[Fiscal Period], 
    'Product'[Category], 
    FILTER(VALUES('Product'[Category]), 
        ('Product'[Category] = "Chilled") || ('Product'[Category] = "Frozen")
    ), 
    "ACT QTY", [ACT QTY], 
    "CMT LAG 1 QTY", [CMT LAG 1 QTY], 
    "ERROR 1 QTY MONTH", [ERROR 1 QTY MONTH]
)

I intend to execute this query within an ADF (Azure Data Factory) pipeline and store the retrieved data into a designated table.

Answer 1

To copy data from AAS via ADF, you would need to create a linked server of AAS with a SQL server.

Note: for that you would need an account with MFA disabled which is a security concern

https://datasharkx.wordpress.com/2021/03/16/copy-data-from-ssas-aas-through-azure-data-factory/

The best way would be for you to use MSFT fabric:

https://datasharkx.wordpress.com/2023/10/31/copy-data-from-azure-analysis-service-aas-through-microsoft-fabric/