910 questions
0
votes
0
answers
158
views
Strategies to map attributes from multiple dimension tables
I'm trying to tackle a requirement in AAS (Azure Analysis Service) tabular model.
In the underlying data model (specific to a particular application), I've a Sales Fact table which joins with multiple ...
- 11.8k
3
votes
1
answer
15k
views
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 ...
- 706
0
votes
1
answer
266
views
Do a select on different column than where clause in DAX?
I wanted to do achieve this “sql” code in a DAX variable
Select WeekYearWeekNumber from DimDate where Date = today()+7
How can achieve it?
So far I have this code, but it doesn’t work because nextw ...
- 706
1
vote
2
answers
1k
views
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, ...
- 2,102
0
votes
1
answer
281
views
Implementing RLS/DRLS in SSAS Tabular vs Power BI
I want to know the difference between implementing RLS or DRLS in SSAS vs Power BI.
If we are implementing it in SSAS tabular should we implement it in the Power BI also ?
We are using an SSAS tabular ...
user9517769
0
votes
2
answers
94
views
Strange number formating in ssas tabular?
I have a ssas tabular cube. I have a question regarding formatting here:
I have number 1,000,000,000.5
By using format: #,##0,.0
it gets displayed as: 1,000,000.5
I have 2 questions:
What's the logic?...
- 706
2
votes
2
answers
4k
views
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....
- 2,102
0
votes
1
answer
78
views
Unexpected Excel Pivot behaviour with SQL Server Tabular model (v2)
We use Excel from Office 365 with a SQL Server 2019 Tabular model
I have a "strange" behaviour of Excel Pivot regarding the level at which calculations are requested from DAX.
I create 3 ...
- 3,795
0
votes
0
answers
64
views
Unexpected Excel Pivot behaviour with SQL Server Tabular model
We use Excel from Office 365 with a SQL Server 2019 Tabular model
I have a "strange" behaviour of Excel Pivot regarding the level at which calculations are requested from DAX.
We have a ...
- 3,795
2
votes
1
answer
2k
views
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 ?
- 146
0
votes
2
answers
2k
views
Microsoft SSAS-Tabular Model (TM) connection to Power BI via Import mode - 'not enough memory available for the application'
I have a rudimentary question, when connecting an SSAS-TM (SQL Server Analysis Services - Tabular Model) database (on-premise) in my own local machine to my Power BI Desktop (also in my local machine) ...
- 465
1
vote
0
answers
81
views
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 ...
- 225
0
votes
0
answers
978
views
Can we use Snowflake cloud data from within Azure Analysis Services?
We are currently using on-premises SSAS-Tabular cubes feeding from the Snowflake Cloud database.
We achieve this using ODBC Drivers to Snowflake.
So far so good but it requires setting up an ODBC ...
- 3,795
0
votes
1
answer
123
views
Create calculated column from a different table
I have a date dimension table and a table that contains the latest date available (only 1 row). There is no relationship between these 2 tables. I'm trying to create a calculated column in Date ...
- 55
0
votes
1
answer
357
views
Cannot live connect to SSAS tabular but can do the import
I have installed SSAS tabular(2019) on my laptop and Power BI desktop (September 2021)
I make a project and deploy then I can see it in the SSMS when I connect to the analysis service. In power bi ...
- 65
0
votes
1
answer
193
views
How to debug DAX formulas in an SSAS Tabular model?
Is there any wa to get the debug of the created DAX final formulas in a tabular model?
- 146
0
votes
1
answer
47
views
Dax add a calculated column
I have a table with different measures and columns, including columns account number, account group, and a measure called Totalsum. I want to add a column called Income with the following 4-row names.
...
- 121
0
votes
1
answer
719
views
MAX Date in Facts using DAX
I have an event fact table that is related to Date dimension through date_key and Event Type dimension though event_key (I use SSAS Tabular Model).
I want to get the max date in a fact table with ...
- 55
0
votes
1
answer
369
views
Can you run a command to process an Azure SSAS Cube from Azure SQL in Elastic Jobs?
I have an Azure SQL database with some fact tables. I have an SSAS Tabular Cube on an Azure Analysis Services database running on the same subscription. The cube's source database is the Azure SQL ...
- 25
1
vote
1
answer
346
views
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 ...
- 31
0
votes
1
answer
35
views
Why I get different Total, but same values?
I needed to replace this measure:
CALCULATE([GM % YTD], SAMEPERIODLASTYEAR('Date'[Date]))
By this one:
VAR VAR1 = ADDCOLUMNS( VALUES(Revenue[Key_Client]),
"Col1", ...
- 706
0
votes
1
answer
94
views
sample data with time dimension for power bi reporting
I am trying to implement Relative-Time-Slicer-and-Filter microsoft documentation steps; I couldn't find a sample data that would help me to achieve this.
Could anyone please help me find the a sample ...
- 159
1
vote
0
answers
35
views
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 ...
- 706
1
vote
0
answers
59
views
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 ...
- 706
0
votes
0
answers
317
views
DAX function to get specific value from dimension?
I have a model with DimCustomer, DimSegment and FactRevenue.
For most cases each customer is associated with a single segment.
There are a handful of Customers, that have two Segments… Therefore, in ...
- 706