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 September 6, 2016 Microsoft BI

Improve performance with DirectQuery by using Inner Joins

If you have ever looked at the queries generated by DirectQuery you will see that a query that retrieves data from multiple tables gets joined... Read more

Posted on September 1, 2016February 9, 2017 Microsoft BI

Power BI Desktop Dynamic security cheat sheet

I recently created this simple Power BI desktop file that allows you to try out dynamic security with the new security relationship feature as described... Read more

Posted on August 25, 2016 Microsoft BI

Use Task Scheduler and PowerShell to process your SSAS database

Most of the times you will use SSIS or a SQL Agent job to process a SSAS model, but sometimes you don’t have either one... Read more

Posted on August 5, 2016February 9, 2017 Analysis Services Microsoft BI

Dynamic security made easy with SSAS 2016 and Power BI

Dynamic security is one of those design patterns you hear mentioned every now and then by the seasoned SSAS pro’s. It is a design pattern... Read more

Posted on August 1, 2016 Microsoft BI

Use any map with Power BI

With the update of Power BI last week you can now add your own maps in any size or shape to Power BI so you... Read more

Posted on July 28, 2016 Microsoft BI

Determine slicer (or visual) influence on other visuals in Power BI

Just a quick one today as I do get this questions every now and then: How can I change which slicers interacts with a visual?... Read more

Posted on July 18, 2016 Microsoft BI

Using multiple enterprise gateways to the same data source

Sometimes you want to be able to offload work for one of your Power BI Gateways as you might have many users who are building... Read more

Posted on July 13, 2016 Microsoft BI

Show only the sales for the last 12 months

Recently I was helping someone on the Power BI community who wanted to only see the sales for the last 12 months in his chart,... Read more

Posts navigation

← 1 2 3 4 … 72 →

Recent Posts

  • Kasper On BI on developing Power BI & life of a Microsoft PM with Kim Manis
  • Kasper On BI on the journey from Excel to Power BI with Shannon Lindsey
  • 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

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