Stack Overflow
Stack Overflow

Questions tagged [azure-analysis-services]

Related to Analysis Services running as the platform-as-a-service offering in Microsoft's Azure cloud.

Based on the proven analytics engine in SQL Server Analysis Services, Azure Analysis Services is an enterprise grade OLAP engine and BI modeling platform, offered as a fully managed platform-as-a-service (PaaS). Azure AS enables developers and BI professionals to create BI Semantic Models that can power highly interactive and rich analytical experiences in BI tools such as Power BI and Excel. https://azure.microsoft.com/en-us/services/analysis-services/

379 questions
2
votes
0 answers

how to import avro file in ADLS in Azure Analysis Service model?

After the support of ADLS as back end in Azure Analysis service , we want to import avro file from ADLS into Azure Analysis service . The file size will be in range of TBs ( 2-4 ) . Azure online documentation tells about csv only and not of avro .…
Kaa
  • 154
  • 6
2
votes
1 answer

How to Connect to Azure Analysis Services from C#?

I'm learning about Azure Analysis Services and I need to build a C# application to query data on Azure Analysis Services I have difficulties finding resources, most cover SSAS and not applied to AAS! Last try now…
user3268044
  • 31
  • 7
2
votes
1 answer

"The command has been canceled.. The exception was raised by the IDataReader interface" Error while processing AAS tabular

I have a large table with roughly 90 million rows and 32 columns, all other tables process fine except for this one. I receive the following error. Failed to save modifications to the server. Error returned: 'The command has been canceled.. The…
Ahmad B
  • 21
  • 1
  • 2
2
votes
0 answers

Using Azure Analysis Services on top of azure data lake store

This is my current workflow: SSIS jobs triggered on a schedule load data from transactional database into a separate database SSAS reprocess is triggered by a SSIS task. I was trying to move to : Use Data Factory to load data from the database…
frictionlesspulley
  • 11,070
  • 14
  • 66
  • 115
2
votes
1 answer

Azure Analysis Services reached maximum allowable memory allocation when creating partitions for table

We have an SSAS tabular model that we want to add partitions to. The server is hosted on Azure with 100GB of memory (the highest tier). We manage to create 5 out of 20 partitions, but when we try to create the sixth partition we get the following…
Robin Johansson
  • 81
  • 4
  • 10
2
votes
0 answers

Parsing WS-Trust response failed when connecting to SSAS

I am trying to connect to Azure Analysis Services in a small web application. The code that I came up with in Microsoft.AnalysisServices.Tabularis: Server as_svr = new Server(); String as_conn_str = "Provider=MSOLAP;Data Source=
Cwiokpl
  • 31
  • 4
2
votes
3 answers

Trying to connect to Azure Analysis Services through SSMS

I've been trying to connect to AZure analysis services through SSMS by using the server name found in the portal. However 2 things are strange: in SSMS the Windows authentication is grayed out and also it is causing me the error as below. Any…
Sambas23
  • 683
  • 1
  • 13
  • 27
2
votes
2 answers

Connection String error while using ADOMD.NET to connect to Azure Analysis

I am trying to retrieve data from Azure Analysis Services using ADOMD.NET from a deployed model in cloud. The code snippet is as below, but i am getting an error that the ConnectionString in invalid. using…
Sijo Kurien
  • 95
  • 2
  • 10
2
votes
2 answers

Azure Analysis Service - Not able to connect to Azure Analysis Service instance from SSMS/VS/PowerBI desktop

I am trying to use Azure Analysis Service in Preview as of today from Microsoft. I have created a new Azure analysis service instance in Azure portal. But when I tried connecting to this instance from SSMS/VS/PowerBI - it fails to connect with…
sang
  • 21
  • 3
1
vote
0 answers

How to pass the logged in username from Power Bi report to azure analysis service?

The task in my hand is to individualize the power bi report based on the logged in user i.e., logged in user should view only the data related to them. We are using Azure Analysis Service(AAS) Database as a data source for the report. We can use Row…
Thamarai Selvan
  • 11
  • 1
1
vote
2 answers

Calculate number of sales days in DAX

1/ How to calculate the number of sales days (= number of days at least one sale has been done)? So far, I created this measure, but I'd like to know if another more optimal solution exists for a large sales table (1b+ records): Sales[No of Sales…
bjnr
  • 3,353
  • 1
  • 18
  • 32
1
vote
0 answers

How to calculate First time pass rate in Azure devops dashboard

The test cases are being maintained in Azure Dev ops, we want to create a Dashboard report for First time pass rate of the test cases executed in each sprint. e.g Sprint 1 Test case 1: Run 1 - Fail | Run 2 - Pass Test case 2: Run 1 - Pass In this…
Naseem Ahmed
  • 11
  • 2
1
vote
1 answer

Which tool can I use on Mac in order to create an Analysis Services tabular model?

I work on macOs and I need to create an Analysis Services tabular model, from some data stored on an Azure Storage. I've seen that, in order to create a tabular model, it can be done from Visual Studio with the Analysis Services Projects extension,…
Daniel Pérez
  • 23
  • 7
1
vote
1 answer

Scalable Power BI data model on delta lake ADLS Gen2

Our current architecture for reporting and dashboarding is similar to the following: [Sql Azure] <-> [Azure Analysis Services (AAS)] <-> [Power BI] We have almost 30 Power BI Pro Licenses (no Premium Tier) As we migrate our on-premise data feeds to…
Federico Lavatori
  • 21
  • 5
1
vote
1 answer

dax difference between filter vs filter values

Can someone explain how the first filter statement is different from second in DAX? FILTER(Table, Table[Column] = "some text") FILTER(VALUES(Table[Column]), (Table[Column] = "some text"))
Sivabose
  • 15
  • 1
  • 4
1 2 3
…
25 26