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
3
votes
1 answer
Exception when trying to reference Azure Analysis Service Tabular Model C#
The problem I get is an exception when I try to reference Azure Analysis Service Tabular Model.
Message=The value '2' is unexpected for type…
Essien
- 67
- 8
3
votes
1 answer
Show only facts in Excel's show fields dropdown when using tabular cube
When having a connection to a multidimensional cube in Excel (powerpivot table) there is an option to Show fields and select only one fact and its related dimensions.
Here is what I mean
This shows only the facts from the model.
BUT
When using…
Pepys
- 981
- 7
- 16
- 34
3
votes
1 answer
Calculating a table vs Importing from server
I have a DW dimensional model as expected, with facts and dimensions and a Date table. This date table goes from 2015 to 2050 with two additional extreme values (1900-01-01 and 9999-12-31).
From this DW, a Tabular model is created which will serve…
Jesus Rincon
- 136
- 9
3
votes
1 answer
Monitoring Tabular Refresh with REST API - Obtaining Refresh ID
I am refreshing tabular models in Azure using a logic app and the REST API. This is detailed here;
https://learn.microsoft.com/en-us/azure/analysis-services/analysis-services-async-refresh
The refresh starts with the POST, which is fine. however I…
James Cooke
- 1,221
- 1
- 14
- 27
3
votes
1 answer
SSAS Tabular Model & Power BI - Week filtering in report
I created an SSAS Tabular Model in VS2017 and the model has a Date Table.
In the Data Table, I have measures to obtain the current week of the selected day (for my model, always TODAY()), and the weeks start on Monday and end on Sunday.
In my Power…
Cassandra Pratt
- 73
- 7
3
votes
2 answers
How to pass credentials for data sources during tabular model deployment?
Problem :
When I deploy the tabular model using deployment wizard. It works fine. But our problems is that we have 20 data sources and at the time of deployment, we need to provide the credentials 20 times as it asks for credentials for every data…
Jitendra Singh Rathor
- 333
- 4
- 13
3
votes
1 answer
Process SSAS tabular model from C#
So I've installed AMO and created the following console application:
using System;
using Microsoft.AnalysisServices;
using Microsoft.AnalysisServices.Tabular;
namespace procesarCuboSSAST
{
class Program
{
static void…
Jack Casas
- 914
- 18
- 37
3
votes
3 answers
Default filter in Power BI - Row Level Security not applied through LOOKUPVALUE
TL;DR: When using LOOKUPVALUE() against a table with Row Level Security, the RLS is not applied and all values are seen
I have a requirement to have a 'default' value (location) picked in a Power BI report, based on the user.
I am reporting against…
Nick.Mc
- 18,304
- 6
- 61
- 91
3
votes
2 answers
SSAS tabular model timeout raised during processing
When doing a Full Process on a tabular model to an Azure Analysis Service model I get the following error after 10 minutes into the processing:
Failed to save modifications to the server. Error returned: 'Microsoft SQL: Execution Timeout Expired. …
Peadar Doyle
- 1,064
- 2
- 10
- 26
3
votes
1 answer
SSAS Tabular Add Column via TMSL
Good Morning,
Objective: I am working on trying to add new columns to a SSAS Tabular Model table. With a long-term aim to programmaticly made large-batch changes when needed.
Resources I've found:…
spencer thomas
- 31
- 2
3
votes
1 answer
How to set password during automated SSAS Tabular deployment?
Dear SSAS Tabular Gurus!
We are setting up an automated build/release-pipeline for a SQL Server Analysis Server Tabular model (SSAS Tabular). For this, we are using Visual Studio Team Services (VSTS) and PowerShell. It will target 3 parallel…
Martin Thøgersen
- 1,538
- 18
- 33
3
votes
1 answer
How to add or subtract seconds from a datetime in DAX
I have a datetime column and a int column representing a number of seconds. I'd like to calculate the sum of the two.
For example:
2017-08-01 18:00:00 + 180 (seconds) = 2017-08-01 18:03:00
The DAX DateAdd function only supports adding a…
Neil P
- 2,920
- 5
- 33
- 64
3
votes
2 answers
Exception when referencing SSAS Tabular model in C#
I am attempting to automate partition refreshes in Azure Analysis Services via C#. I have installed and referenced the latest 'Microsoft.AnalysisServices. ..' assemblies found…
Andrae Gaeth
- 31
- 2
3
votes
1 answer
Passing some (any) kind of context info from SSAS connection string to underlying database
I'd like to have an option to "kind of" impersonate user in SQL database. Is there any part of connection string to analysis server that is passed further into connection string of the underlying database ? In my scenario SSAS instance is using…
Ondrej Svejdar
- 21,349
- 5
- 54
- 89
3
votes
1 answer
Excel PivotTable Group options disabled with Tabular Model
I'm having a lot of fun trying to solve this one.
THE PROBLEM: We have two database 'cubes'. One is a multidimensional (old legacy cube) and one is a tabular model (new). We are trying to phase out the old multidimensional cube.
Client is using new…
Lucky
- 4,443
- 2
- 8
- 18