Power BI : Connect and combine multiple data sources in Azure Analysis Services

[Anonymous]

Hello Everyone,

I am designing this architecture :

Data Lake Store

+ Azure SQL Database OR Azure SQL Data warehouse

+ Azure Analysis Services

+ Power BI

I am asking myself this question :

Is it possible to connect and combine multiple data sources in Azure Analysis Services to create one tabular model ?

Thank you

[v-diye-msft]

Hi @Anonymous 

Please kindly check this post whether it helps:

https://jorgklein.com/2017/12/19/multi-source-partitioned-azure-analysis-services-tables-cold-data-from-azure-data-lake-store-hot-data-from-azure-sql-database/

Actually, your problem is out of my workscope, I'm sorry that I can't provide the best solution. please kindly raise it to the azure community for better advice:

https://azure.microsoft.com/en-us/support/community/