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
0
votes
0 answers
Report builder connectivity issue from different machine
I am trying to connect Report builder from Machine A and my SSRS is deployed in Machine B
Machine A (Client machine with Report Builder 3) --> Machine B (SSRS 2016 - Configured in Native mode)
I am using Windows Authentication and both the machines…
Kannan Kandasamy
- 13,405
- 3
- 25
- 38
0
votes
1 answer
Is it possible to somehow import a Power BI Desktop model to a SSAS Tabular server?
I have a model created using Power Bi Desktop and I want to import it to a SSAS Tabular server.
I'd an idea to start a SSAS Tabular project from a Power BI file (.pbix) similar to how it's possible to create a model from a Power Pivot file but there…
Andrey Morozov
- 7,839
- 5
- 53
- 75
0
votes
1 answer
View Measure definition (DAX) in excel
I am fairly new to DAX and to SSAS-Tabular, so I hope that you'll forgive any ignorance.
We have an SSAS-Tabular cube and we're using it in Excel to see the data (pivot table). Is there a way for me to view the DAX behind a measure in…
Eli
- 2,538
- 1
- 25
- 36
0
votes
1 answer
SSAS changing from multidimensional to tabular error
I've got a installed SQL Server 2014 instance BI edition.
I wanted to change deployment mode from 0 to 2 (multi -> tabular).
And i got this error when restarting the ssas-service in "services":
Anyone stumbled on this error before?
Blixter
- 338
- 4
- 12
0
votes
1 answer
using DAX count number rows where column contains a specific string
In SSAS, I wanted to create a measure that counts the number of rows which the column values contains a specific string.
eg. table
|Id|item
|1|greenapple
|2|blueapple2
|3|yellowapple
|4|purplegrape
search for "apple".
i want the measure return…
jcy
- 1
- 1
- 8
0
votes
1 answer
better design for fact table where each row has a Start & End Date
My fact table contains details for clients who attend a course.
To ensure i can get a list of clients registered on any particular day, I have not related the date dimension to the fact table.
Instead i created a measure that does basic between…
wilson_smyth
- 1,202
- 1
- 14
- 39
0
votes
2 answers
How to make a dynamic measure based on the date chosen
Is it possible to create a calculated measure that calculates differently on the basis by the date chosen dynamically from the related time table "DimDate"?
So i want a static date "2017-01-01" that if less computes [amount]+[count] and if greater…
Blixter
- 338
- 4
- 12
0
votes
1 answer
Row Level Security (RLS) for a SSAS Tabular Model
I am new to SSAS technologies for developing analytical models. I have to build several tabular models for a huge application in which security is quite relevant. What I would like to do is to re-use the row level security existing in the sources of…
Simone Colucci
- 11
- 5
0
votes
0 answers
DAX Function for 'Customers also bought'
My Power BI dashboard contains a product filter and I would need to create a Power BI chart to show 'Customers who bought this product also bought the following ...'. Which would be a bar chart of the products by Price.
My data is flattened,…
Joseph Caruana
- 2,241
- 3
- 31
- 48
0
votes
1 answer
User Name Who Processed SSAS cube
I tried with an MDX query to know the user name who processed the cube.
SELECT LAST_DATA_UPDATE FROM $system.mdschema_cubes
But this will not work.
Is there a way to know the user name who processed an SSAS tabular cube
bipro
- 23
- 7
0
votes
1 answer
Remote connection to Tabular Services
I can connect remotely to Database Engine using MS, but not to SSAS Tabular. Server is in Azure.
Connection to Tabular instance on local server works, with same user (My user is server administrator on SSAS). When I am trying from different server,…
Testtest11
- 367
- 1
- 11
- 26
0
votes
1 answer
Issue with Summarize in SSAS 2014 data model
Good Day all.
I really hope someone can assist with this. The following code works great in DaxStudio and returns a topn…
smckechnie
- 79
- 7
0
votes
1 answer
optimizing dax distinct aggregate
I have a tabular model that is mostly a star schema, except for date, which has no reltionship to the fact table.
The reason for this is all reports run are snapshot reports, i.e. where selectedDate between StartDate & EndDate, i.e. there is no…
JD_Sudz
- 194
- 1
- 12
0
votes
1 answer
Visual Studio 2012 SDT - Tabular Model Designer Issue
I'm trying to create a Tabular Model using Visual Studio 2012 Server Data Tools. I made my install using Multidimensional Schema because I've some reports that are reading data from cubes.
But I want to try the Tabular Model but without disconnect…
John_Rodgers
- 181
- 1
- 11
0
votes
1 answer
Various SSAS Tabular Error Messages That Make No Sense
I've had an SSAS tabular model deployed to a server running SQL Server 2016 for about a month and it has been running fine. All of a sudden, today it is throwing random errors when I try to query it. I just tried to run the same query 8 times and…
User181
- 111
- 8