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

[mvink]

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 Services, which I use for Power BI reporting eventually. The current data source for these AS models is an Azure SQL database.

In my new environment, we have migrated the data to Fabric Lakehouse, and we have build a Fabric Warehouse for our DWH purposes. Actually, we have exactly the same tables (dimensions and facts) in the Fabric Warehouse now as we had in the Azure SQL database. Table names, columns names etc. are the same.

What I want now is to keep the Analysis Service models intact, because all tables, relations and measures there are fine. I just want to change the connection to fill this AS model from Azure SQL Server to Fabric Warehouse. But I can't find a godo way of guide to do this, so I wonder if it's even possible. However, it does not make any sense to me that I have to rebuild a complete AS model just because the data now comes from a Fabric Warehouse and not longer from Azure SQL database.

Does anyone has experience with this and can help me out?

Regards, Mike

[v-pagayam-msft]

Hi @mvink ,

I just wanted to kindly follow up to see if you had a chance to review the previous response provided by us. I hope it was helpful. If yes, please Accept the answer so that it will be helpful to others to find it quickly.

Thank you.

[v-pagayam-msft]

Hi @mvink ,
I wanted to check in on your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply that helped you or sharing your solution. It would be greatly appreciated by others in the community who may have the same question.

Thank you.

[v-pagayam-msft]

Hi @mvink ,

As we have not received a response from you yet, I would like to confirm whether you have successfully resolved the issue or if you require further assistance.

If the issue has been resolved, please mark the helpful reply as a "solution" to indicate that the question has been answered and to assist others in the community.
Thank you for your cooperation. Have a great day.

[v-pagayam-msft · Accepted solution]

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

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

Regards,
Pallavi G.