Skip to content

Kasper On BI

All about Power BI, Modelling, DAX and Microsoft BI

  • About me
  • Kasper On BI Podcast & YouTube
Kasper On BI
  • About me
  • Kasper On BI Podcast & YouTube

Category: Analysis Services

Posted on July 17, 2020August 13, 2020 Analysis Services Power BI

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

Posted on April 22, 2020August 6, 2020 Analysis Services DAX Power BI

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

Posted on April 17, 2020April 20, 2020 Analysis Services DAX Power BI

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

Posted on November 12, 2019November 12, 2019 Analysis Services DAX Power BI

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

Posted on October 22, 2019October 22, 2019 Analysis Services DAX Microsoft BI

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

Posted on May 28, 2019May 28, 2019 Analysis Services

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

Posted on December 17, 2018January 17, 2019 Analysis Services DAX Power BI

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

Posted on October 19, 2018October 19, 2018 Analysis Services Power BI

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

Posts navigation

1 2 3 … 12 →

Recent Posts

  • Launching Kasper On BI YouTube and Podcast, for everything (Power) BI and Analytics
  • Refresh the table fully after setting up incremental refresh with TMSL
  • Hardcoding a calculation group in a measure
  • Calculation group TMSL example
  • Creating a Time intelligence “External Tools” app for Power BI Desktop

Top Posts

  • Show the refresh date\time in a Power BI report and dashboard
  • Currency conversion in DAX for Power BI and SSAS
  • Use IsInScope to get the right hierarchy level in DAX
  • Dynamically switching axis on visuals with Power BI
  • Automatically rotate through Power BI report pages on your browser
Subscribe:

feedburner Via RSS
Via Email

Blog by:
Kasper de Jonge
Program Manager at the Power BI team
Microsoft
linkedin
Terms of use
 
DAX formatted by:
DAX Formatter by SQLBI
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
© 2021 Kasper On BI / Powered by WordPress / Theme by Design Lab