Azure analysis services Scale out replica cost if I need S8v2 replica for 24hrs a month
Hi All, Can the Azure Analysis services Scale out cube replica be provisioned only at the time of cube processing?
Simplifying data landscape with Synapse
How can I use Synapse to simplify my data landscape for maintenance and cost, assuming the lake is always a constant? I currently have two environments: Lake - Databricks(ETL) - Power BI Lake - ADF - AzureSQL - Analysis Services - Power BI I'm…
Error when deleting tables or when modifying column names in the tabular model
Hi, I am using tabular model level 1500. I have a postgres database that is connected to the azure analysis server through an on prem gateway. I have used powerquery to fetch data from the postgres database (via an odbc driver) to the model. I was able…
Unable to access the Azure Analysis services from Visual studio application
Hello All, I have deployed an Azure Analysis Service and enabled the firewall and Power BI. Users are able to access the Azure Analysis Service from Power BI, but they are unable to access it via Visual Studio from their desktops, receiving a network…
Analysis Services taking too much time to refresh SSAS tabular model
Hi, I have a data set of somewhere 40M records in SSMS. My tabular model earlier use to get refresh on S1 tier with 25-30 min. But now I'm using S2 tier and even still its refreshing the data at approx 60 min or sometimes failing and showing timeout…
How to change audience in token used for Azure Analysis Services REST API?
We use the Azure Analysis Services REST API to trigger model updates and refreshes. We received the following email from Microsoft indicating that the audience for the token used to make those requests needs to be changed. You’re receiving this notice…
To Read Delta tables from ADLS Gen2 from Azure Analysis Services (AAS)
I'm not able to Read Delta tables from ADLS Gen2 from Azure Analysis Services (AAS), even though the MS Azure page here https://learn.microsoft.com/en-us/azure/analysis-services/analysis-services-datasource#tab1400a has given an option to read delta…
RLS on Azure Analysis service
I have a fact table and 3 dim table partner ,region and user and my user table contains the usernames and there respective access i:e user1 amazon and America , user2 flipkar and canada , so when ever user 1 logs in he should only see amazon and America…
"An operation that uses the database driver could not be completed. If the driver is a Microsoft driver, make sure the driver file isn't damaged, and if it is, reinstall the driver by reinstalling Microsoft Query."
One of the users receive this error. is this issue at our end or at microsofts ?
Cannot delete Analysis Services
I am trying to delete Analysis Services, but every time I try to, I get this error in the image below: There are no locks for Analysis Services or for my resource group, so I'm not sure what to do. Does anyone know what could be causing this?
I'm using Visual studio 2022 & creating a tabular model but not able to connect to Azure Data lake blob storage - not even able to see that connector
I'm using Visual studio 2022 & creating a tabular model but not able to connect to Azure Data lake blob storage - not even able to see that connector & attaching the screenshot of the connector image. Compatibility level of the SSAS Tabular…
Unable to browse Azure Analysis Services DB in Excel or SSMA
Hello Forum, I have built a tabular cube in VS2022 (compatibility level 1500) which is using SQL Managed Instance as it's datasource in import mode. I have deployed this to Azure Analysis Services. I can connect to the DB in both Excel and SSMS and can…
permissions to refresh a data model in azure analysis services
I am refreshing a data model in Azure Analysis Services using an Azure Function App (C# .NET 6). I am using the Microsoft.AnalysisServices.Tabular package available at https://www.nuget.org/packages/Microsoft.AnalysisServices.NetCore.retail.amd64. When I…
Exception calling "Open" with "0" argument(s): "Could not load type 'Microsoft.Identity.Client.BaseAbstractApplicationBuilder`1' from assembly 'Microsoft.Identity.Client, Version=4.27.0.0, Culture=neutral, PublicKeyToken=
I'm trying to connect to powerbi serivce through PowerShell script from my local system windows 10. I'm getting error 'Exception calling "Open" with "0" argument(s): "Could not load type…
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.…