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 this case it's just my local system): How do I select a user from MS Entra through these prompts? If that can't been done is there another easy UI driven way to impersonate a user? Did Microsoft just not extend support for this authentication type to SSMS(at least for Azure Analysis Services)?

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 batch. > >(Microsoft.SqlServer.ConnectionInfo) 'Cannot initialize the data source object of OLE DB provider "MSOLAP" for linked server "POWERBIAPI". OLE DB provider "MSOLAP" for linked server "POWERBIAPI" returned message "Errors in the OLE DB provider. > >Failed to load managed ADAL component". (Microsoft SQL Server, Error: 7303)

My architecture is as follows: 1. On prem sql server database [Datawarehouse] 2. Azure Analysis Services Tabular model [Sales] 3. International report developers that query the [Datawarehouse] to develop reports* 4. RLS on tables in [Datawarehouse] 5. RLS on [Sales] tabular model For testing that our data makes it correctly from [Datawarehouse] to [Sales] I would like to create a view on the [Datawarehouse] that uses OPENROWSET() to connect to the [Sales] tabular model. The only issue with this is I can see the user that runs the OPENROWSET() query on the [Sales] model is our sql admin user, not myself. Is there a way to configure the OPENROWSET() so that the user that is executing the local query is also the user that executes the query on the linked server? As far as I can tell, passthrough credentials would be the best way to ensure proper security is maintained. *the only reason I mention "international" is because the RLS is based on country

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 the sources. So I installed SSIS and have been trying to connect it to the AAS cube. I first add "Analysis Services Processing Task" to the package. The result looks ok (when I click on "Test connection" the result is positive). But when I click on "Add", it doesn't detect any cubes (there are two on the AAS server specified): I assumed it worked anyway, but I can't query the cube no matter how I try to do that. I added "Execute SQL task", but when I run it, it gives me an error: The error message is: An OLE DB record is available. Source: "Microsoft OLE DB Driver for SQL Server" Hresult: 0x80004005 Description: "Login timeout expired". An OLE DB record is available. Source: "Microsoft OLE DB Driver for SQL Server" Hresult: 0x80004005 Description: "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.". An OLE DB record is available. Source: "Microsoft OLE DB Driver for SQL Server" Hresult: 0x80004005 Description: "Named Pipes Provider: Could not open a connection to SQL Server . ". Error: 0xC00291EC at Execute SQL Task, Execute SQL Task: Failed to acquire connection "asazure://northeurope.asazure.windows.net/xxxx". Connection may not be configured correctly or you may not have the right permissions on this connection. Task failed: Execute SQL Task Warning: 0x80019002 at Package: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. SSIS package "C:\Users\49176\source\repos\Integration Services Project1\Integration Services Project1\Package.dtsx" finished: Failure. The program ' DtsDebugHost.exe: DTS' has exited with code 0 (0x0). Any ideas?

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?

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 this change to take effect. More information on configuring firewall and setting IP address ranges can be found here: https://go.microsoft.com/fwlink/?linkid=2099963 I can go into "Analysis Services" -> "Firewall" and add the IP Address, and then it runs again for a few days, before it fails on a new IP address. This is the Powershell command I'm running $AzureCred = Get-AutomationPSCredential -Name "CredForRefreshCube" Add-AzureAnalysisServicesAccount -RolloutEnvironment 'westeurope.asazure.windows.net' -ServicePrincipal -Credential $AzureCred -TenantId "56cb8dc0-xxxx-xxxx-xxxx-xxxxxxxxxxxx" Invoke-ProcessASDatabase -server "asazure://westeurope.asazure.windows.net/myASCube" -DatabaseName "mydatabase" -RefreshType Full I've checked if DbaTools can work with Analysis Services, and searched high and low for solutions. I've found https://www.inovex.de/blog/azure-automation-analysis-services/ , where I've copied the Powershell code from. How to I ensure that the Automation Services does not change IP, or should I just allow all IP address access to my cube?

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?