Questions tagged [azure-analysis-services]

Use for questions about Azure Analysis Services, the cloud-based platform for running SQL Server Analysis Services.

Azure Analysis Services provides data modeling in the cloud. It is a fully managed platform as a service (PaaS), integrated with Azure data platform services.

With Analysis Services, you can mashup and combine data from multiple sources, define metrics, and secure your data in a single, trusted semantic data model. The data model allows users to browse data with client applications like Power BI, Excel, Reporting Services, third-party, and custom apps.

7 questions
1
vote
1 answer

Azure Analysis Service Tabular Cube - How To Impersonate A User in SSMS

Test Cube, Test User, connect to it(Azure Analysis Service) in SSMS, right click the cube, browse, click on "Impersonate": And you will see a series of prompts that are specific to a on-premise implementation of AD, so local users, local groups(In…
1
vote
1 answer

Can OPENROWSET authenticate with the signed in user running the query?

My architecture is as follows: On prem sql server database [Datawarehouse] Azure Analysis Services Tabular model [Sales] International report developers that query the [Datawarehouse] to develop reports* RLS on tables in [Datawarehouse] RLS on…
1
vote
0 answers

I manage to connect to Azure Analysis Services from SSMS, but not from SSIS

I'm new to the Microsoft Server Suite. I've downloaded SSMS and connected to Azure Analysis Services from it. I'm able to query my data using mdx without any problems. However, I actually intend to build an ETL pipeline with the AAS cube as one of…
1
vote
2 answers

Azure Analysis Service Cube Sizes Changed Since July

we have come across very strange thing the over all size and individual sizes of all AAS cube databases where reduced with out any changes happened. Did anyone saw this change dip and any cause?
JayM
  • 41
  • 7
0
votes
1 answer

Unable to create linked server to Power BI XMLA endpoint in SSMS

Unable to create linked server to Power BI XMLA endpoint in SSMS and getting below error: The test connection to the linked server failed. Additional information: An exception occurred while executing a Transact-SQL statement or…
0
votes
1 answer

Invoke-ProcessASDatabase fails with "Cannot connect to server"

Occasionally I'm getting this error: Cannot connect to server 'myASCube'. Client with IP Address 'x.x.x.x' is not allowed to access the server. To enable access, use the Firewall settings in Azure Management Portal. It may take up to 5 minutes for…
Henrik Staun Poulsen
  • 2,249
  • 2
  • 23
  • 41
0
votes
1 answer

Get Data to connect to the AdventureWorksDW

I am trying to connect to a SQL Server 2017 via Visual Studio 2017.What should I be entering in the User name and Password fields?