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

Posted on September 22, 2017November 15, 2018 Analysis Services Gateway Power BI

Using CUSTOMDATA and On-Premises SSAS with Power BI Embedded

Another Power BI embedded blog post while I have a playground up and running. Often when you want to use SSAS with Power BI embedded... Read more

Posted on September 20, 2017September 27, 2017 Power BI

Embed your Power BI report with predefined filters

I have recently gotten this questions a few times so time to dust off my coding skills and get to work … the key question... Read more

Posted on September 6, 2017September 7, 2017 Analysis Services DAX Power BI

Filter data based on a comma separated list using CALCULATE and PATHCONTAINS, even with external models!

Another interesting question I got this week kind of extends on the previous blog posts where I used disconnected slicers to filter data  but this... 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 15, 2017July 1, 2019 Power BI

Build your own usage report with Power BI

Yesterday I found out we have a great feature in Power BI that everyone should know about but I stumbled upon by accident. it turns... 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 July 7, 2017February 8, 2021 Power BI

Building the Power BI Strava data connector

UPDATE: Strava has changed its auth method, I pushed out a temporary fix that should at least get you to load the data. You have... Read more

Posted on June 1, 2017June 2, 2017 DAX Power BI

Use the Power BI quick calcs with your own date table

Just a quick one today on how you can use the Power BI quick calcs with you own date table. I have a very simple... Read more

Posts navigation

← 1 … 4 5 6 7 →

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