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
1 answer
SSRS Report Date Parameter Error to Query SSAS Tabular Model - The syntax for '5' is incorrect
The actual text of the error as visible in Visual Studio (2015 enterprise) is this.
An error occurred during local report processing.
An error has occurred during report processing.
Query execution failed for dataset 'ProductivityDS'.
The…
MrGoodfix
- 317
- 2
- 14
0
votes
1 answer
DAX in SSMS vs PivotTable in Excel
I have a tabular model where there are some M:M relationships established. I created a measure that did something like M_A = CALCULATE(DISTINCTCOUNT('TableA'[ColA1])) This measure slices just fine in a pivot table when I use DimDate columns, TableB…
chi
- 471
- 3
- 18
0
votes
0 answers
Same period last year. Leap year
I have 3 columns in my SSAS tabular model: Date, Amount, Amount n-1
The problem is that I would like to have for example a row with:
Date Amount Amount n-1
29thFeb 0 2000$
is there any way to deal with leap years…
Jack Casas
- 914
- 18
- 37
0
votes
1 answer
Deploying tabular model to Azure Analysis Services
During deploying tabular model to Azure Analysis Services I get:
Failed to save modifications to the server. Error returned: 'On-Premise Gateway is required to access the data source and the gateway is not installed for the server x.
Technical…
Testtest11
- 367
- 1
- 11
- 26
0
votes
1 answer
DAX formula calculate dates between first transaction and (first transaction + 6 months)
Background: I have a column in a Customer dimension with a static date(e.g '2013-01-01').
This column is the result of a calculation that gets the first transaction date ever made by that certain customer. This customer dimension is linked to a fact…
Blixter
- 338
- 4
- 12
0
votes
1 answer
Exchange rates for ENDOFMONTH
I have an Exchange Rate table that I'm trying to get the ending months calculation
It's using a minimum of 3 currencies lets use GBP USD EUR
I need to return when selecting that currency the End of month Currency
So something like…
user2181700
- 147
- 3
- 15
0
votes
1 answer
deploy and access azure AS tabular project
I've moustly exactly complete steps, described in this post, except that I'm training in northeurope datacenter.
But after succesful deploying model to azure AS I cannot access it with powerBI. It connects to service, but cannot found any models in…
Dmitry Ponkratenko
- 33
- 7
0
votes
0 answers
Join 2 evaluate Queries in DAX
Friends
Today I would like to join the result of 2 evaluate Query in DAX Query can any one have the way to do it? Following are the codes of 2 evaluate queries which i would like to join.
evaluate
(
filter
(
summarize
(
'Total…
Nikhil.Patel
- 959
- 9
- 17
0
votes
1 answer
Filter based on column which is not in summarize "DAX"
Today I would like to generate result based on following "DAX" query but it return following error.
evaluate
(
filter
(
summarize
(
'Date',
'Date'[Numeric Month]
),
AND ('Date'[Numeric Month] >=(YEAR(TODAY())-1)* 100 +…
Nikhil.Patel
- 959
- 9
- 17
0
votes
2 answers
Process only certain partitions of cube
I have a cube that is partitioned by year. I want to do a full process to only the last couple of years, as only data from this period can have changed, been added or deleted. I am unable to figure out how to choose that only certain partitions…
dagrun
- 621
- 3
- 11
- 29
0
votes
3 answers
Unable to create relationships in SSAS 2016 using tabular model programming for compatability level 1200
I am trying to create a simple tool that creates a model from metadata. I am successful in creating tables and columns, but unable to create relationships under model. While trying to add FromTable and ToTable properties to relationship object i was…
vamshi epuri
- 31
- 2
0
votes
1 answer
Catching Power BI queries
How I can catch Power BI queries on Import mode? For Direct Query I can just connect profiler to server, but for Import I have only model.
I need it to check how some complicated reports work.
Kulis
- 988
- 3
- 11
- 25
0
votes
1 answer
Combine two fact tables from two different marts and model in create Tabular model
I have a Fact Table Service1 (open or latest data) from Mart1 and another Fact Table Service2 (historic data) from Mart2. These tables share few common measures and dimensions but the underlying dataset is mutually exclusive.
Now the business wants…
Senthil_Arun
- 1,008
- 9
- 15
0
votes
1 answer
DAX. Previous year Amount
I have a single table in Powerpivot.
My columns are Account, Amount and Date. I want to calculate PrevYearAmount, but I can't fin the correct formula.
Sample data:
Account Amount Date PrevYearAmount
1 100 …
Jack Casas
- 914
- 18
- 37
0
votes
1 answer
Where does DAX MTD calc go?
The stack is SQL relational tables into SQL 2014 Tabular consumed by Excel 2010.
The Tabular model grain is one row per purchase order (PO) line item. Each row has a dollar value (item cost$) which is used for a sum measure (total cost$).
A Time…
DingoCC
- 159
- 1
- 2
- 12