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: Microsoft BI

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 September 1, 2017June 28, 2019 Analysis Services DAX Microsoft BI Power BI

Use calculated tables to show only used rows in dimensions

UPDATE: you can now use measures as filter of a slicer so this post is outdated, please read here for what the recommendation is today:... Read more

Posted on August 9, 2017August 15, 2017 Analysis Services DAX Microsoft BI Power BI

Dynamic data comparisons using disconnected slicers, TreatAs and inactive relationships

Got a good question this week that had me scratching my head for a bit but then I remembered a new function that was added... Read more

Posted on June 7, 2017 Microsoft BI

Embedding Power BI Reports with Power BI Report Server

A common question I get is what will we will be able to do around embedding Power BI reports with Power BI report server. To... Read more

Posted on December 15, 2016February 8, 2017 Analysis Services Microsoft BI

How it is build: the SSAS memory report

So recently I created a new SSAS memory report that you can use to analyze the memory usage of your SSAS servers, read more on... Read more

Posted on November 11, 2016 Analysis Services Microsoft BI

New SSAS memory usage report using Power BI

I have created several version of the SSAS memory usage report here and here. But with the new 1200 compatibility level these memory reports stopped... Read more

Posted on November 7, 2016 Analysis Services Microsoft BI

Analysis Services in Azure, when and why…

As you probably have seen is that Analysis Services is now available in Azure and you can read all about in this great blog post... Read more

Posted on October 13, 2016February 16, 2018 Microsoft BI

Use SQL Server RLS with SSAS and Power BI

One of the questions I get regularly now that SQL Server supports RLS is how can to leverage this with SSAS. What many don’t know is that SSAS... Read more

Posts navigation

1 2 3 … 72 →

Recent Posts

  • The rise of self-service BI, PowerPivot and Power BI and how it changed the world with Rob Collie
  • AI, Machine Learning and Power BI with Rafal Lukawiecki
  • The rise and history of Power BI with Amir Netz
  • Building a Power BI Center of Excellence with Alex Garcia
  • Guest on the Rob Collie (PowerPivotPro), Raw Data By P3 podcast

Top Posts

  • Use IsInScope to get the right hierarchy level in DAX
  • Get the YTD of the same period last year
  • Power BI Desktop Dynamic security cheat sheet
  • How to point existing reports to a new dataset in Power BI (even from AAS)
  • Showing only slicer data that have facts in Power BI (and other fun tricks)
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
© 2023 Kasper On BI / Powered by WordPress / Theme by Design Lab