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 AccountContinue reading “Copy Data from Azure Analysis Service (AAS) through Microsoft Fabric”

Copy Data from SSAS/AAS through Azure Data Factory

Problem Statement : Is it possible to copy data from SSAS Tabular Model / Azure Analysis services from Azure Data Factory (ADF) as ADF doesn’t has an out of the box connector for SSAS/AAS. Prerequisites : Any SQL server wherein we can create a Linked server (So Azure SQL Servers are excluded) 2. SSAS /AAS Tabular ModelContinue reading “Copy Data from SSAS/AAS through Azure Data Factory”

Refresh SSAS Tabular Model from Azure Data Factory

Problem Statement : Is it possible to Refresh SSAS Tabular Model from Azure Data Factory (ADF) as ADF doesn’t has an out of the box connector for SSAS. Prerequisites : Any SQL server wherein we can create a Linked server (So Azure SQL Servers are excluded) 2. SSAS Tabular Model Solution : where Catalog is the SSAS TabularContinue reading “Refresh SSAS Tabular Model from Azure Data Factory”

Design a site like this with WordPress.com
Get started