Connect to two AAS (Azure Analysis) source

[Anonymous]

Hi All - My requirement is to connect to two instances of Azure Analytical Services (AAS) instance using Power BI desktop. Is this possible to perform may be by Importing data instead of Live connection or making use of recently introduced Preview feature of Direct Query approach.

Please provide inputs.

Thanks
Ankit J

[Anonymous · Accepted solution]

Hi @Anonymous ,

It seems that you want to connect to Azure Analysis Services,but there is no available server in your Azure portal ,right?

If so, you could follow the official document to create a server:

For more information, please refer to:

Tutorial - Add a sample model- Azure Analysis Services | Microsoft Docs

Tutorial - Connect Azure Analysis Services with Power BI Desktop | Microsoft Docs

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Once you do a live connection. Try to add some other data source, It should give you an option to convert the live into direct query

[Anonymous]

Hi @amitchandak - Thanks for the response. My issue is that I don't have AAS instances available. It is mainly a confirmation I need to provide to my Business. 

So, is it something you have tried by connecting to multiple AAS sources or can be tested somehow.

Thanks

Ankit Jain

[amitchandak]

@Anonymous , refer if these two links can help you with what you need. I do not have access AAS too

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-datasets-azure-analysis-services

https://corebts.com/blog/power-bi-latest-features-how-to-use-them/