Calculation group TMSL example
Initially I provided a TOM sample to create a calculation group, but you can also interact with the Tabular engine through TMSL using for example... Read more
Category: Analysis Services
Dynamic formatstrings with Calculation groups
One of the cool things of calculation groups is they cannot just be used to apply a calculation over your “base measure” but also apply... Read more
Adding calculation groups to (A)AS or PBI Premium
I was playing around with calculation groups for a question. I found that adding a calculation group is not that straightforward as it should be,... Read more
Find all queries to Azure AS from a Power BI report or dataset
I recently found out the SSAS team added new trace information to Azure Log analytics. The new information allows you to find out the report... Read more
Figure out which columns and measures are used in your SSAS Tabular model
I got an interesting question about being able to figure out which measures and columns are being used for all tabular models in a server,... Read more
Monitoring and Auditing your Azure Analysis Services
I have been using SSAS for years, started years before I started at Microsoft, but most of my real world experience is around using SSAS... Read more
On demand webinar: Strengthen Your Data Modeling Skills with Power BI
I recently did this webinar for Power BI in the studios in Redmond. The webinar goes into details on the data model with Power Query,... Read more
Separate business names from technical names using SSAS and Power BI
I have heard this question come up now and then where someone wants to separate the names and columns seen by users from the names... Read more