Category "ssas"

How to refresh analysis service database using Powershell

What Powershell command refreshes a database in analysis service (SSAS)? I would like to see server parameter and database name parameter too. Also, I want to

Distinct aggregation in pre-calculated measure (MDX)

There are two measures in one fact table \ dimension. Measure 'YearTotal' should somehow be pre-calcuated as a distinct value for any futher summing (aggregatin

Superset - SQL Server Analysis Services Compatibility

I am just starting to look at Apache Superset and wondered if anyone knows or has been able to hook SQL Server Analysis Services up as a datasource? I want to p

SSAS TOM - how to access datasource for PowerBI model

I'm using TOM to interrogate and manipulate a PBIX file open in Power BI. The PBIX file uses a parameter to set the connection string to the sql database that

Visual Studio SSAS Tabular Model does not show existing connections

I'd like to write a SQL Query to extract data from a SQL Table into the SSAS Table. I do not have this option available, as normally I should go over 'Model' &g

How to create partitioning dynamically in SSAS tabular model, without using the SSIS package?

I would like to create the dynamic partition in one of my SSAS tabular model. To do so I found one approach with SSIS package which involves the "Analysis Servi

How convert "blank" to 0 in a card in Power BI with live connection with analysis services?

i have a dashboard in power bi that take data from analysis services. The problem is that can't show a 0 in a card when there aren't values for this filter. in

a function calculate has been used in a true/false expression that is used as a table filter expression which is not allowed

I have a to check the current month and current year value for a measure in ssas tabular model but due to type mismatch i am not able to do this. For this, i ha