Forum Discussion

mvink's avatar
mvink
Frequent Visitor
1 year ago
Solved

Change source for AS model from Azure SQL database to Fabric Warehouse

Hi community,   I have a question and I hope the knowledge within this community can help me out.   In the current situation, I have soms Analysis Services (tabular) models in Azure Analysis Serv...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi mvink ,
    Thank you for reaching out to us on Microsoft Fabric Community Forum!

    To update your Azure Analysis Services (AAS) model to pull data from Fabric Warehouse instead of Azure SQL Database, without having to rebuild everything from scratch .Unfortunately, Fabric Warehouse is not currently a supported data source for Azure Analysis Services (AAS).
    1.  AAS mainly supports Azure SQL Database, Azure Synapse Analytics, and On-Prem SQL Server
          supported-data-sources  

    • Instead, as a workaround,use Azure Synapse Serverless SQL Pool as a Bridge
    • Load your Fabric Warehouse data into Azure Data Lake Storage.
    • Use Azure Synapse Serverless SQL Pool to query the data.
    • Connect AAS to Synapse SQL Pool, which is a supported source.

    2.  If possible,consider moving to Power BI Premium.

    • Power BI Premium datasets connect directly to Fabric Warehouse (unlike AAS).
    • If switching to Power BI Premium is an option, this could save effort in the long run.

    3.  Keep an eye on Microsoft’s updates in case direct support becomes available in the future!

    Please refer this solved link:https://community.fabric.microsoft.com/t5/Data-Warehouse/Connection-from-Azure-Analysis-Service-AAS-to-Fabric-Warehouse/m-p/4017754 

    If this resolved your query, consider accepting it as solution.

    Regards,
    Pallavi G.