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
1
vote
0 answers
Bad Connection: Tableau could not connect to the data source. Error Code: A7AED4D2
I am getting this error when I try to drag one of the measure/dimension on to the visual pane. The tableau server is connected with the SSAS database. I have installed the latest ole db drivers for the server. But the Polybase seems not to start.…
milap
- 11
- 4
1
vote
0 answers
Stress testing of SQL Server Analysis Services tabular model
I have a tabular model in SSAS. Before deploying to production I would like to test the performance of the model in the way: How many users can use the model without any performance issues. When all the resources of the server will be exhausted and…
soldous
- 111
- 1
- 9
1
vote
2 answers
Calculate distinct of a table column plus two static values using DAX
I have a tabular cube that I working on. I would like to get distinct values from "Column1" and then get two additional columns(to be created afresh) as static text one as "All" and other as "2020Q4".
Output would look…
ramadongre
- 95
- 9
1
vote
2 answers
Switch from Power BI Live Mode to Import Model
I am connected to Tabular Model via Live Mode in Power BI. Is there a way I can change from Live Mode to Import Mode. I remember in older versions of Power BI at bottom right corner we used to have the flexibility to change it from Live to Import…
Joseph
- 530
- 3
- 15
- 37
1
vote
0 answers
SSAS :Role Driven Security
I hope you are doing well.
It's about Role Driven Dynamic Security.
And I would like to have your opinion.
I am working on a tabular model deployed on Azure Analysis Service.
I need to implement role-based security rules.
All security roles are…
Lidou123
- 155
- 3
- 15
1
vote
1 answer
Tips to sum values and ignore all filter but the fields of two table in Dax?
I have 3 dimensions tables and one fact Table Sales
DimCalendar (Fields Year/Month/Day/Week)
DimCountry (Field : CountryName)
DimManager (Field ManagerName)
FctSales (Field : Amount)
I want to create a measure to Sum the Amount of the Sales…
MoonLightFlower
- 173
- 1
- 14
1
vote
2 answers
Subtotal <> sum of the rows
I'm a relative neophyte with DAX so bear with me. In the simplest terms, I want to double the measure amount for all regions that are not Europe, then sum the result. Here is some example DAX:
DEFINE
measure Fact[test] = CALCULATE…
justinm1
- 71
- 3
- 8
1
vote
1 answer
Cannot deploy SSAS Tabular Model in Visual Studio 2019
I am trying to deploy a Tabular Model in a local instance of SSAS, I am using SQL Server 2019 Developer edition, and data of the model comes from the example ContosoDW database which is stored in a local instance of SQL Server.
I had two…
1
vote
1 answer
Adding a column to dim table post deployment in a cube
I have deployed a cube in Azure Analysis services and also processed my fact and dim tables. Now I want to add a new column to my dim table A. Can someone help me understand the steps I need to do here? Also, if i change this dim table, will I lose…
Abhinav Nair
- 11
- 1
1
vote
0 answers
'OLE DB or ODBC error: [Expression.Error] Native queries aren't supported by this value
I'm trying create ssas model using following code snippet. I'm able to create model when source is sql server but when the source is apache phoenix i'm getting mentioned error in title. Below is working and not working code, what is the reason it is…
Akshay.Y
- 11
- 4
1
vote
0 answers
OLAPQueryLog does not work for SSAS Tabular mode
I running into a problem when I try to setup querylog in SSAS. The QueryLog Table name has been created already, and WRITE permissions on the table has given to the service account used to run SSAS. I've set the QueryLogSampling value to "1", but…
Tho H. Le
- 11
- 3
1
vote
1 answer
SSAS Tabular Model - Query Mode with Partitions
I'm currently working on a tabular model project and I've been reading about the two modes for query mode: Direct Query and In-Memory.
In the 2012 version for VS there's an option to deploy the solution in Hybrid mode (compatibility 1100 I think),…
Luis Molina
- 11
- 2
1
vote
1 answer
SSAS Tabular model performance problem under high pressure
In our company we have "office Monday", that means every office/shop/department (circa 2000+ distinct user) should generate their reports, especially shops (SSRS with connection to tabular 1500 compatibility level). We are facing very high resource…
msta42a
- 3,601
- 1
- 4
- 14
1
vote
1 answer
Calculate Amount of Inventory Change in Azure Analysis Services DAX
I have data in Azure Analysis Services (Tabular) that looks like the following table. I need to create two calculated columns for the Date that the Inventory Changed and the Amount of the Inventory Change. I think and IF function can take care of…
imani_technology
- 11
- 1
1
vote
0 answers
Tabular Model and Analysis Service and ODBC
From SQL Server 2019, how do I connect to SQL Server Analysis Server (Tabular Model) / Azure Analysis Service using CREATE EXTERNAL DATA SOURCE command?
I would like to connect to it using Polybase and extract data from the Tabular data model.
I…
Gopinath Rajee
- 400
- 5
- 20