442 questions with Azure Analysis Services tags

Sort by: Updated
1 answer

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?

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
442 questions
asked 2024-06-03T11:48:54.8066667+00:00
Noah Cormier-Ratajczak 0 Reputation points
commented 2024-06-11T20:45:07.6066667+00:00
BhargavaGunnam-MSFT 28,106 Reputation points Microsoft Employee
2 answers

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…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
442 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,256 questions
asked 2024-05-31T06:52:56.3233333+00:00
Aravind K Pachaiyappan 0 Reputation points
edited a comment 2024-06-11T11:51:23.16+00:00
Aravind K Pachaiyappan 0 Reputation points
0 answers

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…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
442 questions
asked 2024-06-05T15:07:28.54+00:00
John Foster 0 Reputation points
commented 2024-06-07T15:10:45.2366667+00:00
BhargavaGunnam-MSFT 28,106 Reputation points Microsoft Employee
2 answers

"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 ?

Azure SQL Database
Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
442 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,601 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,256 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,669 questions
asked 2023-10-25T20:03:28.8633333+00:00
zubaid ahmed 0 Reputation points
answered 2024-05-28T13:30:39.0233333+00:00
Gabriel Roldan 25 Reputation points
1 answer

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…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
442 questions
Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
4,476 questions
.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,525 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,256 questions
asked 2024-02-19T11:10:09.8366667+00:00
Muhammad Pathan 25 Reputation points
edited the question 2024-05-16T08:35:29.84+00:00
Muhammad Pathan 25 Reputation points
1 answer

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…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
442 questions
asked 2024-05-07T04:49:12.27+00:00
SivaB 91 Reputation points
commented 2024-05-14T04:09:22.11+00:00
PRADEEPCHEEKATLA-MSFT 82,191 Reputation points Microsoft Employee
2 answers

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
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
442 questions
asked 2024-03-22T11:54:30.7933333+00:00
Molly Myers 15 Reputation points
answered 2024-05-13T14:13:34.09+00:00
Puppal, Akshay 0 Reputation points
2 answers

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 Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
442 questions
asked 2024-02-22T21:04:21.0433333+00:00
Anonymous
commented 2024-05-09T10:02:39.0066667+00:00
James Summerton 0 Reputation points
2 answers One of the answers was accepted by the question author.

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,…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
442 questions
asked 2021-05-18T17:38:56.733+00:00
Gabriel Flores 41 Reputation points
commented 2024-05-08T15:13:10.9866667+00:00
Gabriel Flores 41 Reputation points
1 answer

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…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
442 questions
asked 2024-04-23T16:58:09.58+00:00
Gabriel Hinrichs 0 Reputation points
commented 2024-05-01T09:33:14.5066667+00:00
Amira Bedhiafi 17,786 Reputation points
1 answer

'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
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
442 questions
asked 2024-04-28T21:10:51.77+00:00
Xuhang Song 0 Reputation points Microsoft Employee
answered 2024-04-29T11:58:17.16+00:00
Amira Bedhiafi 17,786 Reputation points
1 answer One of the answers was accepted by the question author.

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.…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
442 questions
asked 2021-07-15T10:16:11.16+00:00
rajendar erabathini 616 Reputation points
edited a comment 2024-04-25T15:29:33.76+00:00
Rogier Wijsman 0 Reputation points
1 answer

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?

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
442 questions
asked 2021-10-22T06:11:12.1+00:00
BHAT-SC, Shivaranjini 6 Reputation points
commented 2024-04-23T22:35:22.6266667+00:00
Eric Ziola 21 Reputation points
1 answer

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…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
442 questions
asked 2024-04-17T09:23:16.97+00:00
Paweł Paleczny 0 Reputation points
commented 2024-04-19T19:36:09.32+00:00
BhargavaGunnam-MSFT 28,106 Reputation points Microsoft Employee
1 answer

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…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
442 questions
asked 2024-04-04T05:47:58.38+00:00
Shrikant Garg1 0 Reputation points
answered 2024-04-04T18:17:35.2833333+00:00
BhargavaGunnam-MSFT 28,106 Reputation points Microsoft Employee
1 answer

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.

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
442 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,256 questions
asked 2024-04-03T07:21:55.98+00:00
Manikant Mahovia 41 Reputation points
commented 2024-04-04T08:07:41.6966667+00:00
PRADEEPCHEEKATLA-MSFT 82,191 Reputation points Microsoft Employee
1 answer

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
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
442 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,881 questions
asked 2024-03-25T08:57:40.7366667+00:00
Poornima 21 Reputation points
answered 2024-03-27T14:26:53.2366667+00:00
Harishga 4,875 Reputation points Microsoft Vendor
2 answers

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…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
442 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,548 questions
asked 2024-03-15T10:11:04.41+00:00
Roel Evers 26 Reputation points
commented 2024-03-20T12:08:20.94+00:00
Roel Evers 26 Reputation points
1 answer One of the answers was accepted by the question author.

Permission on subscription when creating Azure Synapse workspace

I want to create a workspace subscript on Cosmos-bingads-bi, the website prompts me that I do not have the permission. Where should I apply for the permission?

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
442 questions
Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,494 questions
asked 2022-02-17T06:41:21.4+00:00
Jie Li 71 Reputation points
commented 2024-03-08T09:41:11.2566667+00:00
pratapkumar sanjeevi 0 Reputation points
1 answer

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…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
442 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,256 questions
asked 2024-03-05T20:42:07.4366667+00:00
Adam Garcia 0 Reputation points
answered 2024-03-05T23:02:34.99+00:00
Greg Low 1,575 Reputation points Microsoft Regional Director