Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
437 questions
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…
asked 2024-04-17T09:23:16.97+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(124.80000000000001, 28.000000000000004%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPP%3C/text%3E%3C/svg%3E)
Paweł Paleczny
0
Reputation points
commented 2024-04-19T19:36:09.32+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
BhargavaGunnam-MSFT
25,881
Reputation points Microsoft Employee
0 answers
Additional cost to create Log Analytics workspace and Azure Subscription use for Windows Update for Business reports?
Please validate for us that there will be no additional cost to create Log Analytics workspace and Azure Subscription use for Windows Update for Business reports
Azure Monitor
Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
2,786 questions
Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
437 questions
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
923 questions
asked 2024-04-19T16:39:37.4466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 17%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGK%3C/text%3E%3C/svg%3E)
Guneet Kumar
0
Reputation points
asked 2024-04-19T16:39:37.4466667+00:00
Guneet Kumar
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…
asked 2024-02-22T21:04:21.0433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
answered 2024-04-10T20:28:18.2666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 95%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHH%3C/text%3E%3C/svg%3E)
Hooman Haghighat
20
Reputation points
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…
asked 2024-04-04T05:47:58.38+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 22%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
Shrikant Garg1
0
Reputation points
answered 2024-04-04T18:17:35.2833333+00:00
BhargavaGunnam-MSFT
25,881
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.
asked 2024-04-03T07:21:55.98+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(272, 24%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Manikant Mahovia
41
Reputation points
commented 2024-04-04T08:07:41.6966667+00:00
PRADEEPCHEEKATLA-MSFT
76,586
Reputation points Microsoft Employee
1 answer
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…
asked 2024-03-22T11:54:30.7933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(118.4, 77%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Molly Myers
5
Reputation points
commented 2024-04-01T05:18:02.62+00:00
PRADEEPCHEEKATLA-MSFT
76,586
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…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(230.39999999999998, 97%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 48%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
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…
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?
asked 2022-02-17T06:41:21.4+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 45%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJL%3C/text%3E%3C/svg%3E)
Jie Li
71
Reputation points
commented 2024-03-08T09:41:11.2566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(265.6, 20%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPS%3C/text%3E%3C/svg%3E)
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…
asked 2024-03-05T20:42:07.4366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(259.20000000000005, 96%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Adam Garcia
0
Reputation points
answered 2024-03-05T23:02:34.99+00:00
Greg Low
1,245
Reputation points Microsoft Regional Director
1 answer
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…
asked 2024-03-04T08:54:07.1533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(9.6, 51%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHC%3C/text%3E%3C/svg%3E)
Héctor Fernández
0
Reputation points
answered 2024-03-04T21:38:31.6466667+00:00
BhargavaGunnam-MSFT
25,881
Reputation points Microsoft Employee
2 answers
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…
asked 2024-02-26T17:23:14.1466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(160, 7.000000000000001%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Sachin Kumar
1
Reputation point Microsoft Employee
answered 2024-02-29T06:19:04.5833333+00:00
Greg Low
1,245
Reputation points Microsoft Regional Director
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.
437 questions
Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
4,212 questions
.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,346 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,243 questions
asked 2024-02-19T11:10:09.8366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 73%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMP%3C/text%3E%3C/svg%3E)
Muhammad Pathan
25
Reputation points
commented 2024-02-26T08:22:59.33+00:00
PRADEEPCHEEKATLA-MSFT
76,586
Reputation points Microsoft Employee
0 answers
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 Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
437 questions
Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
4,212 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,204 questions
.NET Runtime
.NET Runtime
.NET: Microsoft Technologies based on the .NET software framework.Runtime: An environment required to run apps that aren't compiled to machine language.
1,117 questions
asked 2024-02-08T15:37:05.84+00:00
Muhammad Pathan
25
Reputation points
commented 2024-02-20T15:10:17.6866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 51%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMD%3C/text%3E%3C/svg%3E)
Marc De Vreese
16
Reputation points
2 answers
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…
asked 2024-02-06T11:01:01.4+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 75%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFM%3C/text%3E%3C/svg%3E)
Ferrieri Marco
0
Reputation points
answered 2024-02-12T13:52:26.16+00:00
Ferrieri Marco
0
Reputation points
1 answer
One of the answers was accepted by the question author.
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…
Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
437 questions
Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
4,212 questions
ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,140 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,204 questions
asked 2024-02-01T16:06:56.4933333+00:00
Muhammad Pathan
25
Reputation points
accepted 2024-02-05T15:51:06.7633333+00:00
Muhammad Pathan
25
Reputation points
1 answer
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…
asked 2023-10-30T11:12:40.73+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 37%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
Clare
0
Reputation points
commented 2024-02-02T04:54:53.5333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KranthiPakala-MSFT
46,422
Reputation points Microsoft Employee
1 answer
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.
asked 2024-01-30T14:06:06.3033333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(156.8, 77%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELN%3C/text%3E%3C/svg%3E)
Lakshmi Narayana Sarma Bhamidipati
25
Reputation points
commented 2024-01-31T16:58:34.43+00:00
BhargavaGunnam-MSFT
25,881
Reputation points Microsoft Employee
6 answers
One of the answers was accepted by the question author.
Which is the best option for data warehouse / Power BI solution?
Hello, I am building a data warehouse in Azure from several external data sources. Data can be imported via pipelines in Data Factory (or Azure Synapse). Data is to be stored in Azure. Reporting through Power BI is required. There seem to be a…
asked 2021-10-19T10:02:24.153+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 41%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
System2000
236
Reputation points
commented 2024-01-31T15:35:11.7033333+00:00
Jack Fields
25
Reputation points
1 answer
Raw Data Excel to practice Power BI
Hi team, I'm practicing Power Bi service, I downloaded source from your Github, but data already transformed and pivoted. I want raw data to practice measure and data transformation skills. Can you give me the raw data of these sample: Retail Analysis…
asked 2024-01-28T07:58:23.5233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 13%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDP%3C/text%3E%3C/svg%3E)
Dat. Pham Quoc 2 - CTS TE.CTX.SC
0
Reputation points
commented 2024-01-31T06:46:46.49+00:00
ShaikMaheer-MSFT
37,896
Reputation points Microsoft Employee