Can't save Azure Analysis server admins in the portal
We have two analysis services servers. We have added admins the first and have had no issues. As of yesterday, we created the new server and cannot add admins. When we click add admins, it searches our Entra for users, click the user and select and the…
Azure Analysis Services Pricing Tier has no options
When I view the "Scale - Pricing Tier" option on my Analysis Services instance, I don't get any options. And it doesn't matter if I change from "Recommended" to "View all", still no pricing tier options appear. Anyone else…
Azure SSAS scaling up and down
Below is our scenario: We are on Azure Analysis Services on Tier S1. We'd like to scale up to Tier S2 in the evening to do a full process. After processing is complete, we'd like to scale back down to Tier S1. Questions: When we scale up,…
Problem with AdomdConnection in Data Factory (PySpark)
I'm trying to connect SSAS (Microsoft Analysis Services) through Data Factory using PySpark with the code below but I'm having problems with Adomd mapping. Apparently there is no reference to the dll but I have no idea where it could be mapped as it is…
'The current query cannot be evaluated for the '<ccon>Payment Measures (37)</ccon>' table, because the table contains more than two billion rows.
Hi, We start to get the following errors this week but we have more than two billion rows for years and only have issue start from this week. Is there any new update happening in recent day? Here is the error: Invoke-ProcessASDatabase : Failed to save…
Azure Analysis Services OAUTH token expiry
Hi - Is there any way we can avoid expiring the OAUTH token to connect the data source when processing the tabular cube from SSMS. I believe it expires after 2 hours every time. our team need to refresh the credentials to get that processed every time.…
How do I downscale back to D1 from B1 tier?
Hello, I was trying to refresh my aas via adf and in doing so I had to upscale the tier from D1 toB1 but now I wish to downscale back to D1 as this is done in the dev env and B1 is pretty pricey. Is there a way to achieve this?
Sorting in AAS
Hello All, I'm trying to sort in Visual Studio table by date DESC (like in below screenshot) however when I deploying the model and download it in Excel the date is sorted ASC (second screen). Moreover sorting is not save when I download the model again…
How to fetch data from AAA through custom python code.
I have a AAA which has tabular models. I want to built a custom application may be using python to fetch data from Azure analysis service. How can i do it?are there any python sdk, driver or REST endpoint? Any links or code snippet will really…
SSAS Tabular model 2022 (Disappear specific data import feature)
Hi All, I am unable to find the below feature in SSAS 2022 version, does anyone know how to import specific data into SSAS 2022. The screen below appears when importing data from an existing connection in SSAS 2022. Thanks in advance.
What is Payload error in web activity in ADF while processing azure analysis tabular model
I am using web activity in ADF pipeline to process a table in azure analysis service cube (Tabular model cube). It works fine most of the times but frequently getting below error and the pipeline fails after few minutes or hours when I check the status…
Azure Analysis Services firewall is blocking access from Synapse Analytics pipeline. ADF ip ranges have been whitelisted
Hi, I'm having a hard time refreshing cubes in Azure Analysis Services from an Azure Analytics pipeline. We have the firewall enabled on AAS and supposedly all I would have to is whitelist the ip ranges for the services that need acces.I downloaded the…
Why can't I connect to analysis services from ssms?
I am getting the below error. Is there something I am missing? Unable to obtain authentication token using the credentials provided. (Microsoft.AnalysisServices.AdomdClient) There was an error parsing WS-Trust response from the endpoint. This may occur…
Problema con Backup Automatico en Azure Analysis Services
Buenos días. Hemos desarrollado un sistema de Backups para Azure AS. El caso es que tengo una BBDD Tabular que tarda 1 hora aprox en hacer el backup pero cuando lo programo se queda durante horas y horas ejecutando y no termina. Sabéis si puede deberse a…
Azure Analysis Server becomes unresponsive if tables are getting processed
We have multiple Power BI reports hosted on a server(S9V2) which has multiple databases. We have been noticing that whenever entities are getting processed, the reports are becoming very slow and even the processing of entities take more time than…
Function app not connecting to analysis services server getting Specified method is not supported
I am refreshing a data model in azure analysis services using a azure c# .net6 function app. i am getting Specified method is not supported when trying to connect to analysis services. my connection string looks correct. my server name is correct and…
Azure Analysis Service "There is not enough space on the disk" error during tabular cube process
Hi all, We are using AAS to host a few tabular models; while processing them, randomly, the process fails with the "There is not enough space on the disk" error. As said we're using AAS, not a virtual machine, so we thought that disk space…
Does Microsoft.AnalysisServices.Tabular.NetCore and Analysis services have support for SQL user
I am creating a c# .net 6 azure function app to refresh a data model in azure analysis services. I want to connect to Azure Analysis Services using a connection string using SQL user and password. The docs mention that AAD auth is supported as well as…
Is it possible to open an existing Azure Analysis Services Model in Visual Studio without having to deploy a new model and import data again
Is it possible to open an existing Azure Analysis Services Model in Visual Studio without having to deploy a new model and import data again? The only way I have been able to open an existing AAS model in visual studio is by the following steps: Open…
How to connect to Data bricks catalog database from Azure Analysis services
Hi Friends, There is no native / default connecter from AAS to connect with Azure data bricks catalogue. But is there any work around to achieve this? Please let me know. Thanks in advance.