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.
Impact analysis of deployed on-premise reports on tabular model
What tool do you advice to use when performing impact analysis on-premise? So for instance when changing the name of a field within the tabular model, i would love to find all reports which will be impacted (the reports using the tabular model with the specific field in a dataset).
SSAS Tabular Model DAX measure in paginated report with incorrect result
A paginated Report has a parameter to select a month and year, e.g. March 2021. The following Dax measure through SSAS Tabular Model in a dataset created by Report Builder shows the correct sum: Value1 : = calculate(sum(table1[value1])) Another Dax measure should list the sum of dezember of previous year: Value1 Dez PY : = calculate([Value1], lastdate(previousyear(lastdate(table1[Date]))) ) Table1 contains rows for each product and month like: Date(mm.yyyy) Product Value1 12.2020 A 100 03.2021 B 110 In 03.2021 there is no record for product A. The report output should looks like this: Product Selected Month Last Month Previous Year B 110 A 100 Actually the report does not show the product A and value for Last Month Previous Year Product Selected Month Last Month Previous Year B 110 Any idea how to get also Product A which is not available in 03.2021?