The SQL Server Analysis Services (SSAS) tabular model is an in-memory, column store relational data warehouse constructed with tables which can have multiple columns of data. SSAS Tabular is geared for fast querying and high data compression. The Tabular Engine is the same one used in Power BI, Azure Analysis Services, and Excel Power Pivot.
Questions tagged [ssas-tabular]
869 questions
2
votes
1 answer
How to write if statement with multiple conditions to create a calculated column
so this might be very easy but somehow i dont find a working solution. My problem is as follows:
in a tabular model in ssas i want to create a calculated column
every row of another column should be checked if a certain condition is met and…
nox
- 35
- 5
2
votes
1 answer
Does Azure Data Gateway take advantage of columnstore data?
We have a Tabular model on Azure Analysis Services and we are using the Azure Data Gateway to read from our EDW. As an example, our Fact table is about 100MB using columnstore compression. Uncompressed, it is about 4GB.
My question is, when we…
Gabe
- 5,113
- 11
- 55
- 88
2
votes
0 answers
how to enable 'Date Filters' option for date column in excel for pivoted ssas tabular model
I've got an SSAS tabular model with a column that hold date values. The SQL column is of date type. On the SSAS side, the column data type is Date.
However, when connecting to the model from Excel, I am unable to see date filter option when I click…
Deepak
- 37
- 4
2
votes
1 answer
How different process modes in SSAS tabular work?
We have various SQL jobs for processing SSAS tabular models.
Each job is executed daily, with an interval of the half hour from the previous one.
Currently, we are using the Full Process mode, which consumes a lot of memory and causes some jobs to…
Pratik Bhavsar
- 808
- 8
- 32
2
votes
1 answer
SSAS Tabular Model - Dealing with date and 30 minute time interval
I've created an SSAS Tabular Model in which I have two different tables, AGENT and CHAT, that I would like to be related in order to filter and group by DATE and a 30 minute time interval field called INTERVAL in a Power BI report hierarchy.
Both…
Cassandra Pratt
- 73
- 7
2
votes
1 answer
How to include columns with length greater than 4000 characters in SSAS Tabular Model?
A few of the columns in the source sql view has column length greater than 4000 characters. These are columns which contain some user comments and needs to be inclided in my Tabular SSAS Model.
But whenever the character length is greater than 4000…
Sananda Dutta
- 21
- 1
- 4
2
votes
1 answer
Calculating filtered cost
(Edited for clarity)
I am new to DAX and tabular, and have run into a problem
We have a tabular model with multiple fact tables, sharing some dimensions.
Now our challenge is that cost for one fact, should be calculated on the basis of cost on…
Søren Kongstad
- 1,405
- 9
- 14
2
votes
1 answer
Continuous integration and Deploy SSAS tabular to Azure Analysis Services
I am trying to deploy SSAS Tabular model to Azure Analysis Server through MS Build and Release process.
I am able to successfully execute Invoke-ProcessASDatabase. But I am having problem with Deploying new objects to the Azure Server.
I am using…
ssg
- 23
- 4
2
votes
1 answer
TMSL Creating Multiple Partitions Unrecognised JSON property
Hi all I'm trying to put together a script to create multiple partitions within a tabular data model. I can do one at a time, but multiples seems to be erroring with the following message.
Unrecognized JSON property: partitions. Check path…
Andy
- 63
- 5
2
votes
1 answer
Reduce parallelism when processing a SSAS Tabular model using TOM
I process our tabular models (Compatibility level 1200) using the Tabular Object Model and a powershell script. The script uses some metadata to determine what partitions need to be processed for a given table, and then does a process full on those…
Brandon McClure
- 1,329
- 1
- 11
- 32
2
votes
0 answers
Business Intelligence on Microsoft Visual Studio 2017 appears as not installed
Few days ago I have installed SSDT package with Visual Studio 2017, Business Intelligence environment. I built a solution on SSAS Tabular and when I now want to open it says - Incompatible.
I looked for the Business Intelligence Package, trying to…
Pirvu Georgian
- 657
- 1
- 12
- 37
2
votes
2 answers
How to provide YTD, 12M, and Annualized measures in SQL Server data warehouse?
Project requires a usable data warehouse (DW) in SQL Server tables. They prefer no analysis services, with the SQL Server DW providing everything they need.
They are starting to use PowerBI, and have expressed the desire to provide all facts and…
Chris Adragna
- 625
- 8
- 18
2
votes
2 answers
SSAS 2017 TOM assemblies
We recently upgraded our tabular SSAS instances to SQL Server 2017 (v 14.0.2.04.1) We have a CI/CD process for our tabular models using the TOM library and it works great for compatibility level 1200, but when we change the model's compatibility…
Brandon McClure
- 1,329
- 1
- 11
- 32
2
votes
1 answer
facing error Non-static method requires a target in SSAS TabularTMSL, Power Shell Refresh Script
I am trying to refresh the SSAS tabular Cube hosted on Azure using Power Shell TMSL Script using Azure Runbooks
For larger partitions i am getting following error, I have tried increasing the timeout for Invoke-ASCmd , even with unlimited time out i…
kanna
- 31
- 2
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