910 questions
1
vote
0
answers
62
views
Error occured while running DAX in Power BI which is connected to SSAS using live connect mode
I have connected my SSAS with MS Excel and all the dax which i am running is working fine .
Image of DAX result in MS Excel
But when i am connecting the SSAS with Power BI it is not running as ...
0
votes
2
answers
57
views
SSAS Tabular grand total wrong with hierarchy filter
I am using SSAS Tabular 2022 and has model as below:
The total amount is calculated as
Total Amount:= sum(Amount[Amount])
When I view in Excel and filter the model by the Year-Month-Date, the first ...
- 9
0
votes
1
answer
205
views
Microsoft.AnalysisServices.Tabular Server.Connect() fails with valid token
I'm successfully connecting to a Power BI Service instance to run commands from C# code using AdomdConnection and have problems connecting to the same Power BI Service instance with Microsoft....
- 1,217
0
votes
1
answer
37
views
Filtering data in SSAS based on "AND", not "OR"
In SSAS I have this simple scheme with a list of partners with their tags and the directory of tags. With this scheme, filtering by tags works on the principle "OR" - one of the tags ...
1
vote
1
answer
431
views
Azure SSAS Tabular deploying issue
We are trying to deploy Azure SSAS Tabular model to the server in and getting an error:
outputstringnopump must be called on the UI thread
The "Processing Option" is set to "Do Not ...
- 335
0
votes
0
answers
102
views
Execute TMSL in SSMS
I have TMSL code which looks something like this:
{
"createOrReplace": {
"object": {
"database": "TabularProject1"
},
"database": {...
- 21
0
votes
1
answer
445
views
how to change tabular model in Visual Studio from workspace server mode to integrated workspace mode
I need help resolving a problem in SSAS. I developed a tabular model in Visual Studio (Professional 2022, with the Microsoft Analysis Services Projects extension installed). My model is small. So, ...
- 2,173
0
votes
1
answer
204
views
SSAS 2019 Tabular adventure-works-tabular-model-project-1200.zip Not work in VS 2022 ( Error: Input string was not in a correct format.)
I have on localhost
SQL Server 2019 (1500 compatibilty level) , with SSAS tabular.
AdventureWorksDW2019 DB
VS community edition Version 17.12.3 (with latest SSAS extension) - 2022
Before I worked ...
- 11
0
votes
0
answers
105
views
Row-Level Security in Visual Studio 2022 Tabular Modeling Not Working
I'm adding row-level security to a tabular model using Visual Studio. The data will be processed and stored in Azure and analyzed in Excel. Somehow, I'm not sure how yet, the Azure component means ...
- 110
0
votes
0
answers
79
views
Azure Analysis Service Tabular Cube Compatibility Level Confusion 1608 But API Returns 1600
I have a application written in C# that amongst other things connects to a Azure Analysis Service and moves and alerts tabular cubes, once of the functions I run is a "hotswap" function ...
- 2,743
0
votes
1
answer
92
views
How to Update the Expression of a Measure in a Analysis Services Tabular Model (Power BI Premium) using Invoke-ASCmd
I'm trying to change the expression of an existing measure in a Power BI Semantic Model using Invoke-AsCmd in PowerShell. I have not been able to find any examples of this. What I have so far is this ...
- 73
0
votes
2
answers
42
views
DistinctCount with multiple time intelligence filter
Is there a way to reduce my syntax into single Calculate DistinctCount?
My query
CALCULATE( (
CALCULATE(
DISTINCTCOUNT('Sales Invoice'[Customer Code]),
DATESBETWEEN(DimDate[...
- 1
1
vote
1
answer
46
views
SSAS Tabular - How to avoid the initial delay of the first query in Analysis Services?
I have a database in Analysis Services Tabular and a table with direct query.
When I'm creating a table (without relationships and nothing stranger) and after I do a simple query against that table ...
0
votes
0
answers
378
views
Deployment of Tabular Model Fails in Visual Studio 2022
When I try deploying my tabular model on visual studio 2022, it shows validating credentials and then DEPLOY FAILED with no error message of what made the deployment failed. How do I fix this please.
...
- 1
0
votes
1
answer
74
views
How to exclude two items from an SSAS Pivot table column and select all the rest?
I am trying to filter a column in an SSAS cube pivot table. I want to exclude only two identified values from that column, and select all the rest values.
Somehow my code is excluding many other ...
- 2,018
0
votes
1
answer
42
views
Derived column from 2 dimensions in SSAS Cube
I have two dimension, say "Dimension1" and "Dimension2" in the SSAS cube. I would like to add a derived column in Dimension1 lets say col3 with the logic coalesce (Dimension1.col1, ...
0
votes
1
answer
25
views
Is there an option to remove dimension name in front of column name
I'm using import data from the Analysis Services to excel . Is there an option to not show the dimension in front of the column name on my tabular table?
I will try search in properties of dimension ...
0
votes
1
answer
104
views
How to retrieve all data connections of tabular models on a SSAS instance?
I write you because I have a SSAS instance with many models deployed. I need to extract the information about data connections of all tabular models.
To make an example: I have three models, A, B, C. ...
-1
votes
1
answer
85
views
Calculated table summarizecolumns
I created a table using SUMMARIZECOLUMNS in dax studio.It works.
But when I added the table in my SSAS tabular cube using tabular editor by right click add a calculated table.
When I copy the code in ...
- 91
2
votes
2
answers
106
views
Exclude attribute value by default in SQL Server Analysis Services Tabular Model
SQL Server Analysis Services Multidimensional Model had a functionality to exclude attribute values by default, even though they were not part of any selection. The result would be that records with ...
- 12.8k
0
votes
1
answer
513
views
My SQL Server Analysis services won't switch from tabular to multidimensional
I'm trying to switch the sql server analysis services to multidimensional since I'm getting an error in visual studio when I try to deploy my analysis project that says I can't deploy the model ...
- 311
0
votes
1
answer
52
views
Create an aging KPI where the target/status changes based on a category in SSAS Tabular
I am trying to create a single KPI for support ticket age, but the status needs to take into consideration the "Status Category". I am struggling to figure out how I would set a single KPI ...
- 323
1
vote
1
answer
581
views
Error while deploying Tabular model from localhost to a different server
I have been experiencing a problem when deploying Tabular model from my local machine to a different server (Server X). The error message I am getting is this one:
Basically what I am doing is ...
- 11
0
votes
1
answer
544
views
Why can't I save a new measurement created in my tabular model in Visual Studio 2019?
I am currently working with a BI environment that was developed by a service provider for my company. The infrastructure uses SQL Server 2019 (developer edition) and employs a BI architecture that ...
- 103
0
votes
1
answer
49
views
Configuring Excel File for Automatic Content Activation
I'm currently working on an Excel file that includes external links to my CUBE. Within my cube, there's a Row-Level Security (RLS) function implemented to ensure that a manager can only view data ...
- 77