Stack Overflow
Stack Overflow

Questions tagged [ssas-tabular]

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.

869 questions
1
vote
1 answer

SSAS tabular DISTINCTCOUNTNOBLANK equivalent

I have the data below in SSAS tabular import from sql server create table #Data (ID int,Names varchar(50)) insert into #Data…
JonWay
  • 1,585
  • 17
  • 37
1
vote
1 answer

do a format for only one row?

I have this measure in DAX: SWITCH ( TRUE () , MIN ( 'Dynam'[ID] ) = 5 , DIVIDE ( [Gross] , [Revenue] ) * 100, MIN ( 'Dynam'[ID] ) = 8 , [Hours] ) I would like the first one to have one decimal, but not the second one. Can I do a formatting…
Chicago1988
  • 970
  • 3
  • 14
  • 35
1
vote
0 answers

VisualStudio creates conflict when checking in model.bim files

I have a weird problem working in VisualStudio 2019, with cube .bim files. I usually work on a model.bim, make some changes and then I check in the file... If someone else makes changes in model.bim I will always get this conflict: Is there a way…
Chicago1988
  • 970
  • 3
  • 14
  • 35
1
vote
2 answers

how to create table to hold measures in SSAS tabular cube

I want to create an empty table in a SSAS tabular cube (in SSDT, in Visual Studio) to hold all of my cube's measures. In Power BI Desktop, I would do so by creating a 1-column "empty" table in Power Query, loading it into the model, put 1 measure…
skyline01
  • 1,919
  • 8
  • 34
  • 55
1
vote
0 answers

Get a list of all measures in all pages a pbix uses?

I have several .pbix where I consume from a tabular SSAS. Therefore I can’t see the data: I only see: I connect to cubes that have hundreds of tables and measures, but I only use a subset of them… I want to know which measures and columns I…
Chicago1988
  • 970
  • 3
  • 14
  • 35
1
vote
1 answer

How to fully disable sort on table visual in Power BI?

I have a table visual, where I am only displaying KPIs, so I wanted to fully disable the 'sort' option. By "fully disabled" I mean that when the pbix is published, not even letting a user sort it by clicking it... (If the user clicks the column…
Chicago1988
  • 970
  • 3
  • 14
  • 35
1
vote
2 answers

Get list of SSAS server admins

Is there any easy way to programmatically retrieve a list of SSAS Server Admins? I would love a simple list of: domain\user1 domain\user2 I can manually get a list in SSMS by connecting to SSAS, right clicking the server and choosing Properties,…
TheRizza
  • 1,577
  • 1
  • 10
  • 23
1
vote
2 answers

Excel Power Query truncating text field to 1024 characters

I am accessing a SSAS DMV through Power Query in Excel via: let Source = AnalysisServices.Database(TabularServerName, TabularDBName, [Query="select * from $SYSTEM.TMSCHEMA_EXPRESSIONS"]) in Source This works great in Power BI,…
TheRizza
  • 1,577
  • 1
  • 10
  • 23
1
vote
1 answer

Do we need a scheduled refresh with Live Connection?

I am working on SSAS Tabular project and I am using Live Connection when importing data to Power BI. Do I need to schedule refresh in Power BI ?
Martin James
  • 126
  • 1
  • 3
  • 19
1
vote
1 answer

Display table names

I have a tabular model cube with Compatability Level SQL Server 2016. I assigned the columns and the measures in two different display folders. When analyzing the cube with Excel, the columns and the measures are displayed in two different display…
hana
  • 101
  • 10
1
vote
0 answers

How to use date range in IIF function in MDX Query

Am having 2001,2002 and 2003 years of data in the SSAS server. Without using where clause and filters I need to get the aggregated data using the IIF function in the MDX query for a particular date range. I have referred to many sites but I didn't…
TAMILARASAN R
  • 225
  • 1
  • 6
1
vote
0 answers

Unable to get period over period data from SSAS server using mdx query

Am using the MDX query in the SSAS server. I want to get the current year(01/01/2002 - 31/12/2002) and previous year(01/01/2001 - 31/12/2001) data for a specific date range(dynamically change) in a single MDX query based on the used measure and…
TAMILARASAN R
  • 225
  • 1
  • 6
1
vote
1 answer

How can I save a pivot table connected to SSAS model as static worksheet?

I am working on an Excel report connected to a SSAS model. We need to save the excel spreadsheet as a static Excel file, it means, not connected anymore to the SSAS model. I am using Excel 2016. Is there a way to make this Excel report report a…
Mat.B
  • 31
  • 1
1
vote
0 answers

Make filter to filter in a specific table only?

I have a ClientType dimension connected to Date dim. (ClientType table has columns: ClientNo, Year and Type) In the pbix  I use a filter on: Date dim, on year, which correctly filters my fact in the visualizations… It also correctly filters the…
Chicago1988
  • 970
  • 3
  • 14
  • 35
1
vote
0 answers

How to model tables with different granularity?

I am working on a pbix that consumes from a SSAS cube: I have a fact with Revenue; and dimensions: Date, Client, ClientType. ClientType table: For each Year, each customer has a Type. In the pbix, a single-selection filter on FY will be…
Chicago1988
  • 970
  • 3
  • 14
  • 35
1 2 3
…
57 58