ssas

45 Topics

Power Bi Report Server
I have a 50GB SSAS Tabular Model. Is it logical to create it in a Power BI report or to connect to the tabular model with a direct query? I am using Power BI Desktop RS May 2025 version.
Solved
Bilge
9 months ago Place Report Server
Views
0likes
Comments
Row Level Security - SSAS/Report Server
Hi everybody, I have been struggling lately about how I should implement the "RLS" so that it is reflected in the power bi dashboards. In other words, 1- First, I have designed a SSAS project and implemented roles using dynamic rls and also added desired members 2- Then I deployed the project on an Analysis Server database 3- Creating live connection in power bi and designed my dashboard 4- uploaded the .pbix file on the report server (on-premise). 5- Although I have defined rls in ssas visual studio, all users can see all of the information? and this is something that bothers me. Note: I analyzed my SSAS project in Excel and all RLS configs are working like a charm. (RLS in Power bi -> Not ok, Excel -> Ok) Is there anything else that I am missing which leads to this outcome? I greatly appreciate your help. Thanks, Kasra
Solved
Anonymous
9 months ago Place Report Server
Views
0likes
Comments
SSAS model loading ends in memory failure
Hi, I have one SSAS tabular model running on two servers. On one server (call that server 1) the model loads using full-load without an error. On the other server (call this server 2) the SAME model fails on full-load with memory failure. This server (server 2) has way much more memory configured at server level and sql-server level then the server 1. The data is loaded from the same database tables, so the source of the models on both servers is the same. All ssas parameters are the same, the versions are the same. Software version on both servers : SSAS version 15.0.35.51 SQL Server version 15.0.4440.1 Why does the loading fail on server 2 and not on server 1 ? Help is wanted
Solved
jacccodezwart
11 months ago Place Report Server
Views
0likes
Comments
SSAS Tabular Model performance Issue
Hi I have a SSAS tabular model of almost 2 GB size. I refresh it's data using Azure Analysis Service on S1 tier(P.S. I have tried with S2 tier too but it still consume same amount of time) and refresh request is generated through ADF. Earlier it was working fine and refreshing data with 40 mins for all requested partitions. Now someone has added few new DAX measures to my model and since then me refresh time has increased to 3 hours. I want to optimize my model and reduce refresh time. I am only refreshing the relevant data(current data not the historical data). How can I reduce refresh time and optimize my tabular model. I tried reducing the data but still its taking long time to process the data which is not the ideal case. I guess the effectiveness is effected due to any DAX measure addition but still its just a guess. I dont know the method to identify the cause as I have too many DAX measures in my model.
MAli_Ch
1 year ago Place Report Server
Views
0likes
Comments
Identify DAX Measures consuming too long to process
I have a tabular model on Visual Studio where data size is normal. It use to take 35-40 min to refresh 1 month back but someone added/modified few DAX Measures. Since then it is taking too long too refresh data. I want to indentify measures which are causing this issue. I have used these measures in Power BI reports too. How can I findout these measures so my model can be efficient and start refreshing normally.
Solved
MAli_Ch
1 year ago Place Report Server
Views
0likes
Comments
SSAS consume a lot of memory
Hi, I am analyzing why my SSAS server is consume a lot of memory sometimes what i can see it is not when the model is processing. I have run the dmv Memory usage to find what in SSAS service is take all the memory, and we talk about 115GB memory. My model is only 6GB when loaded in memory. The result of running memory usage can you see below. The what i can see from it, it is the OBJECT ID Big and Small the consume all the memory togeheter. So my question is, what is that? And how can i reduce the consume of memory?
kimpanu
2 years ago Place Report Server
Views
0likes
Comments
Error: Comparison operations don't support comparing values type Text with Values of Type Number
Hi, I'm new to DAX and need some help, I'm creating a measure in a tabular cube in SSAS. I need to retreive the LastYearLastWeek data from x column: LastYearLastWeek:= CALCULATE([x], FILTER(ALL(Time), Time[WeekNumber] = SELECTEDVALUE(Time[WeekNumber]) -1 && Time[Year] = SELECTEDVALUE(Time[Year])-1)) But I get this error in the syntax: comparison operations don't support comparing values type Text with Values of Type Number. Considering using VALUE or FORMAT functions to convert one of the values. Fields used: WeekNumber and Year from Time table are whole numbers. It doesn't really make sense to me, any tips on how to fix it? Also maybe there is a better way to get LastWeekLastYear, do you know of any? Thanks
Solved
Anonymous
2 years ago Place Report Server
Views
0likes
Comments
SSAS Live connection - Current Data
Hello, I am new to the analysis service and I have question about live connection. I am using Power BI SSAS Live connection but every time data is updated in the data warehouse, analysis service needs to be processed (deployed) to load the updated date. as far as I know, analysis service is just a data structure and it is not saving information, thus it must always show actual data without the need to refresh, process or deploying. can someone advise me on how to fix this issue? I want to see live data without SSAS database need to be processed.
Solved
giorgi_lommidd
2 years ago Place Report Server
Views
0likes
Comments
SSIS / SSAS
HI i created a cube in SSIS now i want to use that cubes in SSAS for analysis purpose.. so i want to know how to use it and secondly some one told me that we can not create cubes in SSIS .. is this right help me out
capricon
2 years ago Place Report Server
Views
0likes
Comments
Redshift -> Power BI OR Redshift -> SSAS Tabular -> Power BI?
We want to host Power BI on premise inside AWS. Our unique datasource will be one flattened table in Reshift Some of us want to load the Redshift data into an SSAS Tabular model and report through Power BI using the SSAS model as a datasource. It seems to me that it would be simpler to load the data directly into Power BI rather than through SSAS since both are Vertipaq engines. I suppose an entreprise license would cover both Power BI Report Server and SSAS... Are there any advantages/disadvantages in either approach? Thanks Eric
Anonymous
2 years ago Place Report Server
Views
0likes
Comment