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://video2.skills-academy.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.…
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…