Forum Discussion

OneWithQuestion's avatar
OneWithQuestion
Post Prodigy
9 years ago

Azure Analysis Services: using as PowerBI data source - anyone used it?

https://azure.microsoft.com/en-us/services/analysis-services/   I am very interested in this new offering but had some questions:   1.  How does data refresh work... do we just use a normal Power...
Need Help
v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
9 years ago

OneWithQuestion

 

1. We can open normal connection to Azure Analysis Services. Just put the Azure SSAS server connection string into server name.

 

 

2. Azure Analysis Services pulling on premise data via Azure SSAS on-premise gateway. You need to install it so that you can deploy your Tabular project onto Azure SSAS server.

 

3. I just tested with Azure AS data source. Currently it's only supported to connect live. It will throw invalid server name error when using import mode. We don't need to refresh data since it's live connection. And for cloud data, you don't need to configure Enterprise Gateway on Power BI Service.

 

For more detail information, please refer to Azure AS document below:

Announcing Azure Analysis Services preview

Analysis Services documentation

 

Regards,

robrien6's avatar
robrien6
Advocate IV
9 years ago

Can azure SSAS tabular (connect live) be used in conjunction with azure power bi embedded?

  • vanessa's avatar
    vanessa
    Post Patron
    9 years ago

    robrien6

     

    I don't think that's currently possible.

     

    Check this link. It says supported data sources for direct query are Azure SQL DB & DW.